sp_who2 (MSSQL 2000)[Resolved]

Hey guys by executing exec sp_who2 you get list of information on who's connecting to your sql server. My question is how do I remove a certain list that connecting my sql server?

i.e
lets say I want to remove in the list that has HostName=Bob???

Quote:

---

Originally Posted by mar_zim

Hey guys by executing exec sp_who2 you get list of information on who's connecting to your sql server. My question is how do I remove a certain list that connecting my sql server?

i.e
lets say I want to remove in the list that has HostName=Bob???

---

You can use the KILL command to disconnect spids with hostname=BOB. Just find the SPID in the list, lets say it is 155, and execute KILL 155.

thanks :)