sp_who2 (MSSQL 2000)[Resolved]

[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???

[kaffenils]

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.

[mar_zim]

thanks