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 |
|
Looper
Yak Posting Veteran
68 Posts |
 Posted - 2008-04-24 : 10:47:26
|
| We are in the process of testing our software against sql 2005 as we are about to migrate up from sql 2000. One thing I have noticed is that when we insert data using our import process(.net app) if the string is too long it is truncated but still inserted into the table. but when we run the same against sql 2005 it falls over with error message about string being too long. Is there a setting in sql 2005 etc that needs to be set to allow truncation. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-24 : 11:09:25
|
| Cant really tell with info provided. What is data type of field into which string is inserted? How is insertion happening? |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2008-04-25 : 04:14:02
|
| before you perform migration you need to compare data types and precision between source and destination to avoid such casestruncation is not good...the data is incomplete so it is basically useless?--------------------keeping it simple... |
|
|
|
|
|
|
Field Truncation in 2005