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.