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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-27 : 08:28:35
|
| Robert writes "I am busy Inserting data from differnt SQL servers and Versions .e.g 2000 and 7 into one table.All my 2000 servers return rows fine but my SQL 7 boxes come back with error 'Server: Msg 8152, Level 16, State 2, Line 1String or binary data would be truncated.The statement has been terminated.' I have looked at Microsoft and have found out it has to do with ANSI Warnings being on. but if i change the value from on to off, it errors again telling me it needs ansi warnings on. Please can some one point me in the right direction. Thanks" |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2003-11-27 : 08:38:27
|
Chances are you are trying to insert data into a colums which is not large enoughcreate table test(val char(4))insert into test select 'value is larger than 4 bytes'godrop table test |
 |
|
|
|
|
|
Insert into