How can we help you today? How can we help you today?

truncate columns

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
rick
0

Comments

1 comment

Sort by
  • 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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.