How to find out the users logged in to a SQL Server 2005 database

In order to find out the users logged in to a database, use the system view called sys.sysprocesses.

select * from sys.sysprocesses

returns you a host of information about the login name, Windows user name, processes running on an instance of SQL Server etc.. Check out the hostname, nt_username, loginame, nt_domain columns returned on executing the above query.

Read more about sys.sysprocesses over here

You can also try out the stored procedures sp_who

EXEC sp_who

EXEC sp_who2

sp_who provides information about current users, sessions, and processes in an instance of SQL Server

About The Author

Suprotim Agarwal, MCSD, MCAD, MCDBA, MCSE, is the founder of DotNetCurry, DNC Magazine for Developers, SQLServerCurry and DevCurry. He has also authored a couple of books 51 Recipes using jQuery with ASP.NET Controls and a new one recently at The Absolutely Awesome jQuery CookBook.

Suprotim has received the prestigous Microsoft MVP award for nine times in a row now. In a professional capacity, he is the CEO of A2Z Knowledge Visuals Pvt Ltd, a digital group that represents premium web sites and digital publications comprising of Professional web, windows, mobile and cloud developers, technical managers, and architects.

Get in touch with him on Twitter @suprotimagarwal, LinkedIn or befriend him on Facebook

No comments: