title: Weird problem with an SQL exception truncate string or binary data
body: <p>I'm currently building an app for my work, it work perfectly on my PC but one i put the compile code on to the 2008 server with sqlserver 2005 and run it i get an sql error truncat data.</p>
  
  <p>The weird part is that it aim the same table in the same database and it try to send to same datas.</p>
  
  <p>Any one has an idea?</p>
  
  <p>the error: </p>
  
  <pre><code>Unhandled Exception: System.Data.SqlClient.SqlException: String or binary data w
  ould be truncated.
  The statement has been terminated.
     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolea
  n breakConnection)
     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObj
  ect stateObj)
     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cm
  dHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, Tds
  ParserStateObject stateObj)
     at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
     at System.Data.SqlClient.SqlDataReader.get_MetaData()
     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, Run
  Behavior runBehavior, String resetOptionsString)
     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBe
  havior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehav
  ior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult
   result)
     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehav
  ior, RunBehavior runBehavior, Boolean returnStream, String method)
  </code></pre>