Viewing 10 posts - 331 through 340 (of 340 total)
We had a similar problem. it's not completely resolved, but it looks like the cursor had an empty record set.
August 13, 2008 at 12:43 pm
Yea, there is not much out there on sp_getschemalock or sp_releaseschemalock.
I did find some reference to the locks on the schema (BOL) locks sch-m, sch-s if you do a search.
August 13, 2008 at 12:20 pm
We've found some processes look in the sys.sysservers table. the above mentioned procs do the trick.
you may have to stop and restart the engine, but it most likely can...
August 13, 2008 at 11:01 am
DBCC IND
this link was referenced earlier, but if you are looking for info on the DBCC IND command, this one has it.
August 13, 2008 at 8:18 am
Thanks, this is a good find for waittype's!
August 5, 2008 at 9:13 am
Thanks, but I'm really looking for insight from those who have found ways to capture production traces and use them for performance tuning.
As for the tuning advisor, I've found that...
July 31, 2008 at 8:22 am
Here are my two cents -
I've been working with SQL Server since version 4.21 (1995), and quite frankly, I have not really seen any issues that would be best...
May 12, 2008 at 7:42 pm
Viewing 10 posts - 331 through 340 (of 340 total)