truncate columns

rick@abasoftware.com

I am trying to update a sql db where the old version has varchar(MAX) columns and the new db has varchar(5000) column size. The script gives a message that data would be truncated and basically fails. I want it to truncate, how do I force the script to complete?

I saw somewhere where you can set Ansi warnings off, but I see no such setting.

Thanks,
Rick

Brian Donahue

Hello,
There is no setting in SQL Compare to SET ANSI_WARNINGS OFF. You can save the script to disk, add the set statement to the top of the script, and run it using SSMS or sqlcmd.exe.

Hope this helps.