ViewServerState Property

• Don Cooper-437855

  Old Hand

  Points: 385

  More actions

  December 21, 2007 at 12:00 pm

  #122770

  I (think) I would like to set the ViewServerState Property to true so my business partners can run sp_who2 (SQL 2005). How can I do this in Studio Monitor, either globally (~ 75 login ids) or to a few select ids?

  Thanks in advance,

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  December 21, 2007 at 12:06 pm

  #762270

  You can wrap this in a cursor using dynamic SQL to make it easier for the 75 + logins 🙂

  USE master

  GO

  GRANT VIEW SERVER STATE TO [SomeUserAccount]

  GO

  Tommy

  Follow @sqlscribe