database users and server users

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

General SQL Server Forums

New to SQL Server Administration

database users and server users

Author

Topic

ConnieXujuan
Starting Member

48 Posts

Posted - 2011-12-19 : 18:16:25

Hi -,

Could anyone tell me which system table or view I can query for all real time database users; and which system table or view I can query for all real time server users please?

Thanks a lot!

Connie

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-12-19 : 18:17:40

What do you mean by "real time"? Are you referring to currently connected users? If so, you can query master..sysprocesses/sp_who/sp_who2/etc. If not, please clarify what you mean.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2011-12-21 : 01:41:21

If you want to track in detail - use Profiler. Note:Profiler uses resources on the Server and may have some impact on server performance

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources