Removing SysAdmin role for login

• Arul Manoj

  SSC-Addicted

  Points: 440

  More actions

  March 27, 2009 at 3:32 am

  #130226

  Hi,

  I have a SQL account with the name SCBAdmin with SysAdmin role. Now i want remove the SysAdmin role for this SCBAdmin login using SQL scripts.

  Please any one help me with this.

  Also how to change the owner of the SQL jobs.

  I am using SQL 2005 with SP2.

  Thanks

  Manoj

• 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]