String truncated..? 1

[kenjoswe]

Hi all,

I've tried to do a simple insert query and I get:

Server: Msg 8152, Level 16, State 9, Line -1074284091
String or binary data would be truncated.
The statement has been terminated.

How can I select to the line "-1074284091" to see what is wrong with it?

/Kent J.

 

[DuncFair]

You don't have to see the line. Your simple insert query has tried to insert a string that exceeds the length allowed for the target column.

If you set ANSI WARNINGS off, the query will run (and truncate the string or binary data).