Script Server Roles

• Rasmus Glibstrup

  SSC Enthusiast

  Points: 121

  More actions

  August 26, 2010 at 10:01 pm

  #387676

  Comments posted to this topic are about the item Script Server Roles

• andrei_solntsev

  SSCrazy

  Points: 2196

  More actions

  August 29, 2010 at 5:30 pm

  #1213580

  Hi Rasmus,

  it is possibly to simplify your script up to one select statement ;-):

  SELECT 'EXEC sp_addsrvrolemember '''+pr.name+''', '''+pm.name+''''

  FROM sys.server_role_members AS rm

  JOIN sys.server_principals AS pm ON rm.role_principal_id=pm.principal_id

  JOIN sys.server_principals AS pr ON rm.member_principal_id=pr.principal_id

  WHERE pr.name <> 'sa'

  AND pr.name NOT LIKE 'NT SERVICE%'

  AND pr.name NOT LIKE 'NT AUTHORITY%'

  Kind regards,

  Andrei

• Jon.Morisi

  SSChampion

  Points: 12846

  More actions

  October 18, 2012 at 8:50 pm

  #1550714

  Thank You!

  --First Create sp_help_revlogin and use it to migrate logins

  --Second run this to update the server roles

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 18, 2016 at 1:06 pm

  #1879989

  Thanks for the script.