367 reputation
311
bio website schoolofficepro.com
location United States
age 41
visits member for 3 years, 5 months
seen Oct 30 at 20:39

School Office Pro.

We provide web based applications for schools to enable online registration, ecommerce, hr, surveys, mass email broadcasting and more.


Aug
27
comment How to get Identity Column to jump ahead (by say 1000) on SQL Server 2012
For the future, this situation is why GUIDs where invented: stackoverflow.com/questions/371762/…
Jul
2
awarded  Curious
Jun
30
answered MS SQL Server Cumulative Updates - Best Practices
May
6
accepted Move log file without taking database offline
May
6
comment Move log file without taking database offline
Well alrighty then. Thanks.
May
6
asked Move log file without taking database offline
May
6
accepted Select statement is locking a record
May
6
answered Select statement is locking a record
May
6
comment Select statement is locking a record
It was ODBC. I'm answering this below
May
6
awarded  Notable Question
Mar
19
comment At what point does one database per client become unfeasible?
You might read this, specifically note the dates and the ops comments: stackoverflow.com/questions/5596755/…
Nov
28
awarded  Popular Question
Oct
11
awarded  Popular Question
Aug
23
comment DBCC checkdb showing failure after a restore
I ran the repair_allow_data_loss option, then I simply deleted all the remaining records out of that table. After running dbcc checkdb again it came back and said all was good.
Aug
23
accepted DBCC checkdb showing failure after a restore
Aug
23
asked DBCC checkdb showing failure after a restore
Dec
10
comment Pivot rows into multiple columns
This worked. THanks
Dec
10
accepted Pivot rows into multiple columns
Dec
10
comment Pivot rows into multiple columns
BTW, I have to use the OPENQUERY syntax. The tables have oracle timestamps which prevent me from hitting them directly. The error code is ORA-00933
Dec
10
comment Pivot rows into multiple columns
When I tried to exec this across the linked server I get an error about sql command not properly terminated