BizTalk Server - How to install stored procedures

Author

How to install stored procedures

Bill Q

2007-03-05, 7:17 pm

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.

Bill Q

2007-03-05, 7:17 pm

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