May 12, 2009 at 8:02 am
how can i change maintenance plan owner in SQL2005
May 12, 2009 at 8:14 am
The easiest way is to log into SQL Server with the desired account and change the name of the maintenance plan, and then change it back. Open each sub-plan and re-save to update the jobs with the new owner.
You may need to also make a change on at least one task to force an update of the job, but I have found that most of the time that is not needed.
Another option is to update the table directly, but that is a bit more difficult.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 12, 2009 at 10:57 am
Check out this blog post, shows how to do it:
http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/05/04/dyk-maintenance-plans-have-owners.aspx
Andrew
December 3, 2010 at 1:54 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply