Script Server Roles

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Rasmus Glibstrup » Script Server Roles

Script Server Roles

Rate Topic

Display Mode

Topic Options

Author

Message

Rasmus Glibstrup

Posted Thursday, August 26, 2010 10:01 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:01 AM
Points: 53, Visits: 107

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

Post #976118

andrei_solntsev

Posted Sunday, August 29, 2010 5:30 PM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, May 09, 2013 6:12 PM
Points: 815, Visits: 143

Hi Rasmus,

it is possibly to simplify your script up to one select statement Wink

:

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

Post #977128

Jon.Morisi

Posted Thursday, October 18, 2012 8:50 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:12 AM
Points: 275, Visits: 679

Thank You!

--First Create sp_help_revlogin and use it to migrate logins
--Second run this to update the server roles

Post #1374628

« Prev Topic | Next Topic »

Permissions