Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Icetips Article
Back to article list
Search Articles
Add Comment
Printer friendly
Direct link
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.
Today is November 21, 2024, 8:27 am This article has been viewed 35185 times.
|
|