permissions master..sysperfinfo

• Steve Vos

  Right there with Babe

  Points: 757

  More actions

  May 21, 2008 at 5:15 am

  #122162

  I am trying to create a script which adds db, then adds tables and stored procedures.

  In the end I also want to add permissions.

  the permissions file is found as attachment

  I cannot get acces with the user nagios to the master..sysperfinfo table..

  help please.

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  May 21, 2008 at 7:28 am

  #818544

  For 2005 the recommendation is to use sys.dm_os_performance_counters instead of the old sysperfinfo.

  sys.dm_os_performance_counters requires VIEW SERVER STATE permission.

  /Kenneth