How to override the String or Binary Data being Truncated
Posted on 2009-07-15
Shared hosting Query Analyzer.
Hi, all. I have a SQL 2005 db on a shared host (GoDaddy).
I have duplicated a table on there (Giving it a diff name, of course), and I am now trying to copy the data from Tbl1 to Tbl2. All is coming over fine, except for the "MAX" fields in Tbl1.
I have changed those values in Tbl2, as I am using Classic ASP, and it does not play nicely with the "MAX" fields.
So, if I set the Tbl2 respective field/column to "varchar(4000)", and run an UPDATE script to copy from Tbl1 to Tbl2, it continues to give me the error message:
"String or binary data would be truncated. The statement has been terminated."
Is there any way to override this, as I do not care if it truncates it?
Thanks so much,