Cannot Load the BTS_Tracking_Archive_Purge_Script.sql File in SQL Server (829312)



The information in this article applies to:

  • Microsoft BizTalk Server 2002 SP1

SYMPTOMS

Microsoft BizTalk Server 2002 Service Pack 1 includes an updated version of the script file BTS_Tracking_Archive_Purge_Script.sql for the InterchangeDTA database. However, this file is corrupted. You cannot load this file in Microsoft SQL Server.

RESOLUTION

A supported hotfix is now available from Microsoft. To obtain this hotfix, follow the instructions that appear in the following Microsoft Knowledge Base article:

327467 FIX: The Dta_purge_old_records Stored Procedure May Cause Exclusive Table Locking

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

The BTS_Tracking_Archive_Purge_Script.sql file that is included with BizTalk Server 2002 Service Pack 1 is corrupted. You cannot open this file in Notepad or load this file in SQL Query Analyzer.

Modification Type:MajorLast Reviewed:10/29/2003
Keywords:kbfix kbbug KB829312 kbAudDeveloper