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 |
|
Mondeo
Constraint Violating Yak Guru
287 Posts |
 Posted - 2008-12-11 : 05:51:20
|
| Hi,I know what the error means - but is there an easy way to see which column is causing it, i've got quite a complex insert statement and its going to be difficult to track down otherwise.Thanks |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2008-12-11 : 05:59:26
|
| check once ur varchar fields in ur table length of varchar fields is less than ur passing string so that error occurs |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-12-11 : 07:52:29
|
quote:
Originally posted by Mondeo
Hi,I know what the error means - but is there an easy way to see which column is causing it, i've got quite a complex insert statement and its going to be difficult to track down otherwise.Thanks
There is no direct way to know thisMadhivananFailing to plan is Planning to fail |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-11 : 10:20:31
|
quote:
Originally posted by Mondeo
Hi,I know what the error means - but is there an easy way to see which column is causing it, i've got quite a complex insert statement and its going to be difficult to track down otherwise.Thanks
probably you can track it down to which part by commenting and checking each inserts one by one |
|
|
|
|
|
|
String or binary data would be truncated error