Showing posts with label add group. Show all posts
Showing posts with label add group. Show all posts

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