August 17, 2004 at 12:54 pm
A co-worker just came to my desk and asked if I knew anything about DBCC WAKEUP. I unfortunately do not. It appears to be an undodumented DBCC command and I'm wondering if anyone might have any knowledge of this command. The original thought was that it may be useful in a job we have that monitors blocking.
August 17, 2004 at 1:27 pm
I think that this used to be used in Sybase to wake up a sleeping thread - it takes a SPID as an argument. Whatever it used to do, it doesn't do anything now, apparently. If you try to execute it (in SQL2K) you'll get this message:
DBCC WAKEUP not implemented. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
A builtin way to get commands to execute repeatedly with a delay in between (if that's what you're trying to do) is to use a WHILE loop with a WAITFOR delay.
Cheers,
Chris
August 17, 2004 at 1:42 pm
I was aware it existed but never have used so not sure of the impact but here are some others http://www.novicksoftware.com/TipsAndTricks/tip-sql-dbcc-help.htm
Many are internal use only and undocumented.
August 18, 2004 at 2:40 am
You weren't dozing at your desk when your colleague mentioned this command to you?
Antares - Cheers..That's a handy list
Eoin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply