Who are you

In next couple of posts i will explain about some very usefull stored procedures in SQL Server.

SP_WHO
The sp_who stored procedure is used to display all database users who are currently logged onto SQL Server. The stored procedure also displays the processes currently running on SQL Server.

Look at the below example to report all current users

USE master
GO
EXEC sp_who
GO