357 reputation
311
bio website schoolofficepro.com
location United States
age 41
visits member for 3 years, 1 month
seen Aug 15 at 20:15

School Office Pro.

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


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
Dec
10
asked Pivot rows into multiple columns