Hello Sir, I have joined in a concern as a SQL SERVER DBA.I am a fresher . i got so many problems regarding sql server. at present i got problem like one application hangs the database not the server. i have found out the stored procedure which gives problem. but i want to know that whether it is possible to write procedure which kills the process if it resides in sleeping state for long time Expecting reply eagerly Regards, Raja V please send reply to the following id only;

-- Anonymous, April 11, 2003

Answers

Raja,

Yes you could do that with the KILL command. The KILL command terminates a user process based on the system process ID (SPID) or unit of work (UOW). If the specified SPID or UOW has a lot of work to undo, the KILL command may take some time to complete, particularly when it involves rolling back a long transaction.

Hope this helps,

Eric

-- Anonymous, April 14, 2003