Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kingsgambit
Starting Member
4 Posts |
 Posted - 2011-08-19 : 08:15:19
|
| I have task with importing jobs from sql 2000 to sql 2005I have imported to jobs ok but they will not run Sql Job isql -Uinsphireuk –Pinsphireuk110468 -n -i D:\Intranet\hirreps\SCRIPTS\abandoned.sql -o d:\Intranet\hirreps\abandoned.htmError messageMsg 102, Level 15, State 1, Line 1Incorrect syntax near 'Uinsphireuk'.Msg 132, Level 15, State 1, Line 1The label 'd' has already been declared. Label names must be unique within a query batch or stored procedure. |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2011-08-19 : 10:22:56
|
| If you open this file in a query window: "D:\Intranet\hirreps\SCRIPTS\abandoned.sql" will it run successfully? I suspect not. That would mean that sql server 2005 has a problem parsing the sql statements in the script where as 2000 did not.Be One with the OptimizerTG |
 |
|
|
|
|
|
Import sql jobs from 2000 to 2005