Here is T-SQL script to find all the members present in the SQL Server roles.
SELECT SUSER_NAME(members.role_principal_id) AS [ServerRole] ,logins.name AS 'RoleMember' ,'EXEC sp_addsrvrolemember ''' +logins.name+''', '''+ SUSER_NAME(members.role_principal_id)+'''' AS [Command to add role members] FROM sys.server_role_members members, sys.server_principals logins WHERE members.role_principal_id >=3 AND members.role_principal_id <=10 AND members.member_principal_id = logins.principal_id and logins.name <>'sa'
1 comment:
Thanks for the sensible critique. Me and my neighbor were just preparing to do some research on this. We got a grab a book from our area library but I think I learned more clear from this post. I’m very glad to see such great information being shared freely out there. https://royalcbd.com/product/cbd-gummies-25mg/
Post a Comment