Monday, September 20, 2010

Find who is connected to database in a current instance

in Sqlserver 2005 system stored procedure "sp_who" can be used to get information about current users and processes in an instance of the Microsoft SQL Server Database Engine. The information returned can be filtered to return only those processes that are not idle.

No comments:

Post a Comment