I am trying to purge old records from the InterchangeDTA table.
http://msdn2.microsoft.com/en-us/library/ms958275.aspx says to "install
stored procedures".  The directions are not working for me.  Specifically, I
can't open C:\Program Files\Microsoft BizTalk
 Server\Setup\BTS_Tracking_Archive_Purge_
Script.sql.  The file appears to be
encrypted.

[ Post a follow-up to this message ]

The documented install procedure did not work.  So, I found a server that
already had dta_purge_old_records and dta_gmt_convert stored procedures.  I
copied the contents of the stored procs, including a Create statement.  I
then ran the create scripts on other BizTalk/SQL databases.

"Bill Q" wrote:

> I am trying to purge old records from the InterchangeDTA table.
> http://msdn2.microsoft.com/en-us/library/ms958275.aspx says to "install
> stored procedures".  The directions are not working for me.  Specifically,
 I
> can't open C:\Program Files\Microsoft BizTalk
>  Server\Setup\BTS_Tracking_Archive_Purge_
Script.sql.  The file appears to b
e
> encrypted.
>

[ Post a follow-up to this message ]