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 |
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
 Posted - 2010-04-09 : 11:16:58
|
We are running MS SQL Server 2000 Our Developers want to be able to View the Activity Monitor in Production. Is there harm in giving them GRANT VIEW SERVER STATE TO <<login name>> or is there another way to give them this access?? |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2010-04-09 : 16:29:10
|
| Apart from the fact that VIEW SERVER STATE is not a SQL 2000 permission?You may be able to grant them the processadmin server role, but you should read up on the permissions associated with this role, just to be sure you are comfortable with them. |
 |
|
|
|
|
|
GRANT VIEW SERVER STATE