Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Database

Author  Topic 

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2011-06-10 : 13:41:19
Is there way through sql queries to track the users logged to the database.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-06-10 : 13:44:30
You can exec sp_who or sp_who2 and get some basic information. For more detail you can select from sys.dm_exec_sessions and sys.dm_exec_connections.
Go to Top of Page
   

- Advertisement -