Home Forums SQL Server 2005 Administering Removing SysAdmin role for login RE: Removing SysAdmin role for login
MarkusB
SSC-Dedicated
Points: 37370
More actions
March 27, 2009 at 3:47 am
#967264
Simply use sp_dropsrvrolemember to remove any login from a serverrole like sysadmin.
EXEC sp_dropsrvrolemember 'yourLogin', 'sysadmin'
With sp_update_Job you can change the owner of a job.
[font="Verdana"]Markus Bohse[/font]