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.
| Author |
Topic |
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
 Posted - 2013-05-09 : 14:24:44
|
| Hi im not able to view the active users from query analyzer.i've only db_owner permission in database. Do i need any other role to be mapped? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-09 : 15:02:49
|
| Quoting from MSDN "Requires VIEW SERVER STATE permission on the server to see all executing sessions on the instance of SQL Server. Otherwise, the user sees only the current session."http://msdn.microsoft.com/en-us/library/ms174313.aspx |
 |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-05-10 : 03:16:21
|
| Try with admin role and see if it works |
|
|
|
|
|
|
sp_who2 active