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 |
|
DeveloperIQ
Yak Posting Veteran
71 Posts |
 Posted - 2008-11-24 : 13:34:23
|
| On my test server 1 running SQL 2000 with SP4, when insert data into a temp table by doing a join on a column which contains bad data (eg. ******) to another column which is an INT, I get an error "Msg 245, Level 16, State 1, Line 2Syntax error converting the nvarchar value '**********' to a column of data type int." whereas on my test server 2 running SQL 2000 with SP3, I dont get this error and the rows are inserted fine.The tables in question have the exact same data and number of rows and I have verified that. Can anyone help with this? |
|
|
DeveloperIQ
Yak Posting Veteran
71 Posts |
Posted - 2008-11-24 : 14:13:43
|
| This seems to be an error caused by different versions of SP on SQL 2000. And apparantely, SQL 2000 SP4 fixes a bug which causes this error to appear as opposed to SP3 which completely ignores this error. |
 |
|
|
|
|
|
An Error with Insert