Skip to content

Instantly share code, notes, and snippets.

@zippy1981

zippy1981/LoginToSysadmin.sql

Created February 8, 2011 22:06
Show Gist options
  • Save zippy1981/817375 to your computer and use it in GitHub Desktop.
Save zippy1981/817375 to your computer and use it in GitHub Desktop.
Download ZIP
Script to make a windows user a sql server sysadmin
Raw
LoginToSysadmin.sql
--- First we create a login from our user
CREATE LOGIN [domain\justin.dearing] FROM WINDOWS;
GO
-- Now we make him sysadmin
EXEC sp_addsrvrolemember
@rolename='sysadmin',
@loginame='domain\justin.dearing'
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment