Mega Code Archive

 

Categories / MSSQL Tutorial / User Role

 

Managing Server Role Members

CREATE LOGIN Veronica WITH PASSWORD = 'YourPass' GO EXEC master..sp_addsrvrolemember 'sysadmin' GO EXEC master..sp_dropsrvrolemember 'sysadmin' GO