April 19, 2008 at 12:28 am
sp_who2 shows the block by user and some information.Currently we are moving from sql 2000 to sql 2005. if i execute the sp_who2 in sql 2005 it shows only my login block information. it does not show other users. is there any admin rights has to give to view other block user ??? how to do that.
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/code to get the best help[/url]
- 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/code to get the best help[/url]
- 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/code to get the best help[/url]
- 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 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply