Par2: Stored Procedures duplicating in MS SQL 1998-06-15 -- Steve Olensky The MSSQL ODBC driver will create temporary stored procedures for each SELECT that CW sends. I recommend that you turn this option OFF (in the ODBC DSN Setup). The procedures tend to fill up TEMPDB and crash the server, this is especially true if you are doing any type of batch operation that generates a lot of SELECTs in one session. This is done in the ODBC Administrator: Open a MS SQL datasource from the controlpanel|ODBC admin, Press the options button. You will see a check box "Generate Stored Procedure for Prepared Statement" Uncheck this box. Note: CW creates a stored procedure on the fly for a SELECT -- shp. Printed May 2, 2024, 8:00 pm This article has been viewed/printed 35111 times. |