Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Sysprocesses

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-15 : 10:30:47
ky.lau writes "Anyway to kill a process where the status shown is runnable status under SQL Server 6.5 ? The status is obtained from the "select * from master..sysprocesses""

scottpt
Posting Yak Master

186 Posts

Posted - 2002-05-15 : 10:33:48
use "Kill {spid}"
You get the spid from sysprocess.

Go to Top of Page
   

- Advertisement -