If you are getting the following error in MSSQL. String or binary data would be truncated.  Then put the following before your script and it shall run fine.

SET ANSI_WARNINGS OFF

You can check the database to see if its on or not by going to the following.

Enterprise Manager -> Right Click the DB -> Properties -> Options.  It will say ANSI warnings to true or false.  True is on false is off.

By defualt the db is set for false(off)