Can you kill processes in SQL Server 2K without stopping SQL Server and restarting it? I am using sp_who2 to get a list of active users and I see some accounts that are logged off but still showing up and I am trying to find a way to Kill these accounts and the processes they are doing.you can use
1) KILL 53(spid)
Or
Enterprise Manager-->Management-->current Activity-->Process Info
you can pick specific spid and kill it from here..
SS|||What do you mean logged off?
Sleeping?
How many connections are we talking about?
Do you see the Login?
Can you NET SEND them a message?
Better off to leave them alone...It takes resources to reestablish them...
Anyway you'll love this...
It's KILL <spid>|||Do I just do this in the Query Analyer?
No comments:
Post a Comment