Adding 'sysadmin' users to SQL

[GobBluth]

Is this correct?

CREATE LOGIN [DOMAIN/USER] FROM WINDOWS
EXEC sp_addsrvrolemember 'domain/user', 'sysadmin'

GRANT CONTROL SERVER TO [DOMAIN/USER]

Thanks in advance,

GB

 

[KLin]

Looks good. Grant control server statement is redundant since users in the sysadmin role have 100% access to a SQL server instance.