magritton
8/4/2015 - 12:15 PM

SQL create login from windows and add to server role

SQL create login from windows and add to server role

CREATE LOGIN [opwftg\Administrator] from WINDOWS

EXEC sys.sp_addsrvrolemember  @loginame = 'OPWFTG\Administrator', @rolename = 'sysadmin'