Moving Data and SP from Ms SQL Server 7 to SQL Server 2005
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 ?