String or binary data would be truncated?????!!! 1

[Dineedshelp]

Help!!!

I have a stored procedure that has run with no problems, until now and it is returning the above error. I have increased the field sizes in the table tbut to know avail. Is there any way I can track down which record(s) are causing the problem?

This is the error I receive:

Server: Msg 8152, Level 16, State 4, Procedure sp_FillEmployee_New, Line 22
String or binary data would be truncated.
The statement has been terminated.


Thanks!!!!

 

[SQLSister]

OK you can look on line 22 to see what possible fields the problem is in. To find the length of the largest item in the field:

Select max (len(Field1)) from table1

Check that length against the variable it is being loaded to or the field in another table it is being inserted into.

Questions about posting. See faq183-874

 

[Dineedshelp]

Thanks, from this I managed to sort the problem!!!