You might want to try DTS, there is an option to copy SQL Server jobs from SQL7 or SQL2000 to another SQL2000 server.

Brian Freeman
(770) 916-0595 ext. 415
Carnegie Technologies/Bluewave Computing
www.carnegie.com and www.bluewave-computing.com

Fang, Elaine wrote:
> Thanks! Any idea about the jobs on the old server?
>
> -----Original Message-----
> From: Ferguson, Keena [mailto:[Email Address Removed] Sent: Wednesday, July 23, 2003 9:43 AM
> To: Fang, Elaine; LazyDBA.com Discussion
> Subject: RE: detach & attach
>
>
> Edit DTS and do a "save as" and signify the new server works for me
> ...
>
> Keena Ferguson
>
> Sr. Database Administrator
> Comdata Corporation
> [Email Address Removed] 615-371-3483
> www.comdata.com
>
>
>
> -----Original Message-----
> From: Fang, Elaine [mailto:Elaine.[Email Address Removed] Sent: Wednesday, July 23, 2003 9:34 AM
> To: LazyDBA.com Discussion
> Subject: detach & attach
>
>
> Hi list,
>
> Does detach & attach include DTS package and job? If not, how can I
> move it over after attach?
>
> thanks,
> Elaine
>
>
>
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page