INFO: Turn Off Temporary Stored Procedures with SQL Server

ID: Q197809

The information in this article applies to:


When using SQL Server with Microsoft Transaction Server (MTS), it is important to turn off the use of temporary stored procedures for prepared SQL statements.

Prepared SQL statements are executed using the SQLPrepare and SQLExecute ODBC API functions. ADO and RDO make extensive use of prepared statements in certain circumstances. SQL Server will create temporary stored procedures when executing prepared SQL statements if the database connection is configured to do so. This can cause undesirable side effects when SQL Server is used with MTS. To prevent this you must either:


The use of temporary stored procedures for prepared SQL statements may have the following unwanted effects:

Keywords          : TSrvGen TSrvODBC TSrvProg 
Version           : WINNT:1.0,2.0,6.5
Platform          : winnt
Issue type        : kbinfo

Last Reviewed: December 29, 1998