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 |
|
manju3606
Yak Posting Veteran
78 Posts |
 Posted - 2011-08-04 : 08:06:38
|
| Hi,can anyone explain me How to Grant view server state to loginManju |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-08-04 : 13:33:27
|
| 1. Right click on server name.2. Select properties.3. Select Permissions4. Select user/group to whom you want to give permission.5. In permission tab select view server state. |
 |
|
|
manju3606
Yak Posting Veteran
78 Posts |
Posted - 2011-08-04 : 14:28:40
|
| Thanks dude..........Manju |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-08-04 : 14:46:55
|
There's also the T-SQL...wait for it...GRANT VIEW SERVER STATE TO myLogin That seems familiar, where have I seen that before? |
|
|
|
|
|
|
How to grant view server state to login