Mahesh .NET Blog
Saturday, February 23, 2008
SQL-Server : How to Kill the Database Users?
To view the Users who are all using the Database:
--------------------------------------------------
sp_who2
To Kill the User:
------------------
kill 'SPID'
eg: kill 58
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment