MSX SQL server error is caused due to change in computer name after installing SQL Server. To fix this error you have to run these two statements in Query analyzer
1) list the jobs
select * from msdb..sysjobs
2) update the originating_server
update msdb..sysjobs
set originating_server = 'your new computer name'
where originating_server = 'your old computer name'
Tuesday, July 7, 2009
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment