Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
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 May 2, 2024, 6:16 pm This article has been viewed 35111 times.
|
|