script login permissions at database, server level

• wayne.r

  SSC-Addicted

  Points: 441

  More actions

  May 11, 2012 at 12:08 pm

  #257873

  Hi, I was moving databases to a new server (SQL2005) and taking the ones on the existing server (SQL2000) offline. I had also to copy over some of the logins. I was not sure what happens to the explicitly granted server permissions like view server state, etc.

  Can this be scripted out?

  Please let me know. Thank you.

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  May 11, 2012 at 7:59 pm

  #1486685

  GRANT VIEW SERVER STATE TO <<login name>>

  This will grant <<login_name>> VIEW ANY STATE permission.

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)