Pearl writes "MICROSOFT SQL-DMO (ODBC SQLSTATE:42000) error 14274: cannot add, update or delete job that originated from an MSX server. I am getting this error message because my SQL server used to be called something else and i created a database maintenance plan then and now i can delete or amend it without getting that error message. Please help.
Maintenance plans are easy to create using the wizard. Why don't you copy the original plan's steps in a new one then delete the original? (This doesn't answer your question but at least your dbs will be backed up, checked & optimized again).
I think the problem is Pearl changed his/her server name without re-installing SQL Server. This would mean his/her plan would be trying to look for old server name instead of the new one. This can cause problems in other places, not just maint plans.
Cannot edit Job created when SQL Server had a differnet name
Posted - 06/12/2001 : 22:26:41
