Thanks very much for the reply, I'll give it a go.
I wasn't sure if I would have to use DTS on MSDB on
SysJobHistory
SysJobs
SysJobSchedule
SysJobServers
SysJobSteps
Seemed rather over the top!
I am upgrading the hardware of our MS SQL 2000 server, and I want to migrate all the jobs to the new server. I know how to export them as scripts, but have been unable to find out how to import them to the new server. If anyone can point me in the right direction, as to how this is done, I'd be...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.