<div>
I guess there is not short and sweet way of doing so other than just checkout all string column with it's size and comparing it with the data your inserting or updating.
</div>


I guess there is not short and sweet way of doing so other than just checkout all string column with it's size and comparing it with the data your inserting or updating.

<div>
I guess nothing can show you which column is culprit.
</div>


I guess nothing can show you which column is culprit.

<div>
<div class="content wysiwyg-content">
During the import of a table with about 80 columns and 1 million rows, I've received the error that &quot;String or binary data would be truncated&quot; ... however, SQL 2005 doesn't tell you which column is being truncated. &nbsp;<br />
<br />
Is there any way to determine this, perhaps more robust error message options, etc.? &nbsp;A setting somewhere in SQL that will give more details? &nbsp;Or an error log I'm not aware of that would tell me more information?<br />
<br />
I know how to fix the error itself ... my question is about getting more information out of SQL as to what the exact error was.<br />
<br />
Thanks<br />
<br />
<br />

</div>
</div>


During the import of a table with about 80 columns and 1 million rows, I've received the error that "String or binary data would be truncated" ... however, SQL 2005 doesn't tell you which column is being truncated.  

Is there any way to determine this, perhaps more robust error message options, etc.?  A setting somewhere in SQL that will give more details?  Or an error log I'm not aware of that would tell me more information?

I know how to fix the error itself ... my question is about getting more information out of SQL as to what the exact error was.

Thanks




String or binary data would be truncated - Determining Which Field ?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.