Is there a problem with Connection pooling and stored procedures?
With connection pooling on, connections are returned to the pool, and tempdb is never freed with the connection. Therefore, before turning on connection pooling for SQL Server, it is strongly recommended that you turn off the option to create stored procedures for prepared statements. To turn off this option, double-click your store’s system datasource in the ODBC Administrator in Control Panel and clear the Generate Stored Procedure for Prepared Statement check box. Important If you turn connection pooling on and you do not turn off Generate Stored Procedure for Prepared Statement, your system may not work. For performance to improve, you must turn off Generate Stored Procedure for Prepared Statement for each ODBC datasource that the Commerce Server stores use. In addition, after you turn off the option for each datasource, you must restart IIS.
