Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-14 : 11:04:59
|
| Anees Ahmed writes "Last week we shifted our database platform on development server in our company from SQL Server 7.0 to SQL Server 2000. Therefore I restored backup of all our databases on live server to development server. This included the MSDB databases which was on live which contained Around 95 DTS packages which I use to integrate our WEB SQL server data with our ERP Symix. But now when i try to change/modify/delete any package on development server I am getting a error(Below)Error 14274:cannot add,update, or delete a job (or its steps or schedules) that originated from a MSX Server.Due to this reason all the jobs are enabled and I am not able to disable them. Therefore I have stopped the SQL ServerAgent on Development Server.please help me, How I can solve this Problem?." |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-14 : 11:31:04
|
| See article:http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281642&id=281642&SD=MSKBThat provides a workaround, however if that is not feasible, or if that doesn't work, you can update the sysjobs table with the new servername. However, I would strongly suggest opening an MS PSS case before attempting that on your own. This is a bug in SQL 2000, so your case will be free.-Chad |
 |
|
|
|
|
|
Problem after restoring MSDB Database.