I'm setting upp new machine with Win Srvr. 2003 and SQL server.
My old Win2K server is running SQL 7 with SP4, I want to move one DB and associated SP from SQL 7 to SQL 2005 but can't succeed

While on SQL 2005 Srv Managemt, I tried to connect to the SQL 7 and Copy Database (and assiciated SP). I did not take DB offline, but this shoudl not matter...

I get error on last Action (Execute SQL Server Agent Job), "The job failed".

PS. Will the SP from SQL 7 work on SQL 2005 ?