BUG: You may receive a "String or binary data would be truncated" error in the SQL Server error log in BizTalk Server 2004

When you work with Microsoft SQL Server Database Tracking and Archiving (DTA) in Microsoft BizTalk Server 2004, you may notice truncated data and you may receive the following error message in the SQL Server error log:

This behavior may occur if you work with DTA and your data is larger than the space that is allocated in Microsoft SQL Server to house the data.

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. To fix this problem, adjust the size of the column of data that truncates the data. To increase the size of the column that truncates data, run the following SQL statement against the BizTalk Server database:

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

Steps to reproduce the behavior

1. Create the document tracking database. To do this, follow these steps:
   1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
   2. Type Use ArchiveTrackingDatabase, and then click Execute.
   3. On the File menu, click Open. The Open Query File dialog box appears.
   4. In the Look in list box, locate \Program Files\Microsoft BizTalk Server\Setup.
   5. Click BTS_Tracking_ArchiveDB_Schema.sql, and then click Open.
   6. On the Query menu, click Execute.
2. Configure a receive pipeline that will track fields that have a path that is larger than 80 characters but is less than 1,024 characters.
   
   Note For more information about how to create a receive pipeline, see the following BizTalk Server 2004 tutorial:
   http://go.microsoft.com/fwlink/?LinkId=26435
3. Process documents through this receive pipeline.
4. Archive the tracking data.