Microsoft KB Archive/829312

= Cannot Load the BTS_Tracking_Archive_Purge_Script.sql File in SQL Server =

Article ID: 829312

Article Last Modified on 10/29/2003

-

APPLIES TO


 * Microsoft BizTalk Server 2002 Service Pack 1

-



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.

Keywords: kbbug kbfix KB829312

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.