Jul 26, 2006 #1 swreng MIS Jun 22, 2006 90 GR Dear all, Is it possible on sql server 2000 to see how many users are connected on a specific database with script? Thanks a lot
Dear all, Is it possible on sql server 2000 to see how many users are connected on a specific database with script? Thanks a lot
Jul 26, 2006 #2 SQLDenis Programmer Oct 1, 2005 5,575 US run this in query analyzer exec sp_who2 Denis The SQL Menace SQL blog:http://sqlservercode.blogspot.com/ Personal Blog:http://otherthingsnow.blogspot.com/ Upvote 0 Downvote
run this in query analyzer exec sp_who2 Denis The SQL Menace SQL blog:http://sqlservercode.blogspot.com/ Personal Blog:http://otherthingsnow.blogspot.com/