Any SQL Server wizards here?
We have an issue where a call to sp_spaceused causes the code to freeze up when it tries to get the size of tempdb. Not only that, but right-clicking on tempdb and selecting Properties in Enterprise Manager causes EM to freeze up.
And just to make things more fun, runing sp_lock from the query analyzer never completes. It just goes on and on and on...
WTF is all I can say. Is tempdb corrupt somehow? Everything else seems to be working fine.
We have an issue where a call to sp_spaceused causes the code to freeze up when it tries to get the size of tempdb. Not only that, but right-clicking on tempdb and selecting Properties in Enterprise Manager causes EM to freeze up.
And just to make things more fun, runing sp_lock from the query analyzer never completes. It just goes on and on and on...
WTF is all I can say. Is tempdb corrupt somehow? Everything else seems to be working fine.