which user Login

[SQLBaby]

How can i check which user login with which databses, any procedure or command which shows these information.

Thanks

Knowledge is a key of success.

 

[JamesLean]

Do you mean you want to see which databases a specific login has access to? One way is to double-click on the login from within Ent Mgr (Security -> Logins container) and look in the Database Access tab.

--James

 

[SQLBaby]

no, actualy we have many users in other states too, and some time we need to check that how many and and who is logedin right now with databse "ABC", so we know these persons are working on this datbase right now.

Knowledge is a key of success.

 

[JamesLean]

To see current connections execute sp_who, or use the Current Activity window in Enterprise Mgr (in the Management container under the server).

--James

 

[SQLBaby]

Thanks JamesLean, it works.

Knowledge is a key of success.