How to install stored procedures   

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.

date: Mon, 5 Mar 2007 11:54:20 -0800   author:   Bill Q

RE: How to install stored procedures   

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 be 
> encrypted.
>

date: Mon, 5 Mar 2007 14:24:08 -0800   author:   Bill Q