April 19, 2008 at 9:36 am
- with sql2005 you can only see the data you are entitled to.
- you need to grant 'view system state' to see it all.
Do you realy need to do that ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 21, 2008 at 6:24 am
[font="Courier New"]In SQL 2005 you can make use catalog views or DMV's for the same. You will get more information compared to sp_who2.. Users need view server state permission. Refer the below link.
Database Management Views & Functions - SQL 2005
[/font]
Regards..Vidhya Sagar
SQL-Articles
April 22, 2008 at 4:08 am
How to give permission 'view system state' in sql 2005 ???
April 22, 2008 at 6:04 am
grant VIEW SERVER STATE to xyz ;
Check "GRANT Server Permissions " in BOL.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 12, 2008 at 4:15 pm
The following dm views also need "View Server State" to function
sys.dm_exec_sessions
sys.dm_exec_requests
sys.dm_exec_connections
Therefore these cannot be substituted for sp_who2 which also needs the same permission
April 19, 2012 at 6:05 pm
hi, i'm new in this forum but i have a question, where i can find the sp_who2 script for sybase V15.5? thanks a lot.
April 20, 2012 at 1:07 am
onix-81 (4/19/2012)
hi, i'm new in this forum but i have a question, where i can find the sp_who2 script for sybase V15.5? thanks a lot.
For Sybase I wouldn't know. This is a SQLServer oriented forum :discuss:
Nowadays, many of us use Adam Machanics solution Who is Active
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 7 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply