How do I add an active directory security group to a sql server sysadminrole

Question: How do I add an active directory security group to a sql server role such as sysadmin role

Answer:
EXEC master..sp_addsrvrolemember @loginame = N'\', @rolename = N'sysadmin'
GO

No comments:

Post a Comment