SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Cannot edit Job created when SQL Server had a differnet name
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 06/12/2001 :  22:26:41  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
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.

Cheers,

P"

RickD
Slow But Sure Yak Herding Master

United Kingdom
3603 Posts

Posted - 06/13/2001 :  09:39:12  Show Profile  Reply with Quote
Did you re-run the setup for SQL Server when you changed the name of your server?

Go to Top of Page

PeteWright
Starting Member

United Kingdom
2 Posts

Posted - 06/13/2001 :  11:01:03  Show Profile  Reply with Quote
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).
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3603 Posts

Posted - 06/13/2001 :  11:45:29  Show Profile  Reply with Quote
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.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000