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 |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2008-04-19 : 02:26:11
|
| 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. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-19 : 17:30:51
|
| What kind of permission do you have on the server? |
 |
|
|
niranjankumark
Posting Yak Master
164 Posts |
Posted - 2008-04-22 : 06:02:38
|
| I have select permission in sql 2005. but same permission i had in sql 2000. but i could view all block user. could u help me how to procedd |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-22 : 23:13:36
|
| You need VIEW SERVER STATE permission. |
|
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-07-30 : 15:34:46
|
| How to do the VIEW SERVER STATE permissions? |
|
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-07-30 : 15:36:48
|
| I dont want to give any permissions other than sp_who2,what do i need to do? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-30 : 22:51:15
|
| >> How to do the VIEW SERVER STATE permissions?With grant command.>> I dont want to give any permissions other than sp_who2,what do i need to do?Non-sysadmin user with exec permission on sp_who2 can't see other processes on the server, that's why need VIEW SERVER STATE permission too. |
|
|
|
supersql
Yak Posting Veteran
99 Posts |
Posted - 2008-11-11 : 13:26:26
|
| what is the impact of giving VIEW SERVER STATE permissions to a non admin, is it advisable? |
|
|
|
|
|
|
sp_who2