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 |
|
Mafer
Starting Member
1 Post |
 Posted - 2007-01-03 : 18:10:11
|
| Hi,Please help meGetting the following error in a stored procedure:"Server: Msg 8152, Level 16, State 9, Line 1 String or binary data would be truncated. The statement has been terminated."Problem is, it's a *huge* stored procedure and I can't pin down where the error is occuring.Can someone help meThanks Mafer |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-01-03 : 18:46:35
|
| u are either doing an update or insert, and the value is too large for the field.say you have a column defined as varchar(32). this error occurs of u try to insert a string length 33+to find, select * from source where len(field) > 32may have to execute similar query for each string or binary column to find offending data |
 |
|
|
|
|
|
Server: Msg 8152, Level 16, State 9, Line 1 String