SQLServerCentral.com / SQL Server 2005 / SQL Server 2005 General Discussion / String or binary data would be truncated. / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 31 Mar 2015 15:00:12 GMT20RE: String or binary data would be truncated.http://www.sqlservercentral.com/Forums/Topic428579-149-1.aspxyes the set option is defined at the procedural levelFri, 18 Jan 2013 04:02:56 GMTrevathybtchRE: String or binary data would be truncated.http://www.sqlservercentral.com/Forums/Topic428579-149-1.aspxYes it is set in ProcedureMon, 03 Dec 2007 23:49:47 GMThaichellsRE: String or binary data would be truncated.http://www.sqlservercentral.com/Forums/Topic428579-149-1.aspxIs the SET option defined at the PROCEDURE level?Mon, 03 Dec 2007 06:25:39 GMTRamesh SaiveRE: String or binary data would be truncated.http://www.sqlservercentral.com/Forums/Topic428579-149-1.aspxHi,Thanks for the response. But my query is why the record is getting inserted in one Server by truncating the last character and why it is throwing the error in another server.Mon, 03 Dec 2007 06:18:44 GMThaichellsRE: String or binary data would be truncated.http://www.sqlservercentral.com/Forums/Topic428579-149-1.aspxHi !Increase the lenght of your column.Sun, 02 Dec 2007 22:33:55 GMTabmoreString or binary data would be truncated.http://www.sqlservercentral.com/Forums/Topic428579-149-1.aspxI have a SP where i have given SET ANSI_WARNINGS ON. Inside the SP i am creating a temp table (# table) where i am inserting a record which is greater than its defined length. i.e the column of temp table is nvarchar(30) and i am trying to insert 31 characters. In one server the string data is truncated to 30 chars and inserted whereas when i execute the same in another server it is giving error like String or binary data would be truncated. Please provide the reason for thisSun, 02 Dec 2007 21:48:41 GMThaichells