February 3, 2013 at 11:57 pm
how many DBA currently accessing same database ? how to check
February 3, 2013 at 11:59 pm
sp_who2
February 4, 2013 at 12:07 am
Thanks
February 4, 2013 at 4:18 am
getsimrangujral (2/3/2013)
how many DBA currently accessing same database ? how to check
You specifically cant check who is(DBA or have sysadmin rights)accessing database, instead you can find the persons/tasks accessing the database with their respective logins.
Sp_who2 gives details with the help of spid.See http://sqlserverplanet.com/dba/using-sp_who2
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 4, 2013 at 4:20 am
removed
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply