how to allow truncates in a procedure

[bebblebrox]

hi,

i have a procedure which occasionally generates the following error:

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

is there any command I can issue prior to running the script so that such truncations would be allowed?

 

[mrdenny]

You need to modify your table or variable deffinitions. One of more string or binary fields is smaller than the data you are trying to insert into the field or variable. For example you are trying to put the value 'XXX' into a field that is varchar(2).

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[bebblebrox]

what i really want to do is trap that error and insert the record causing it into another table.

doable?

 

[bebblebrox]

never mind, i had an error in my error handling. traping now.