` MSSQL temp Stored Procedures (Scott Ferret ) - Icetips Article
Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

Icetips Article

Back to article list   Search Articles     Add Comment     Printer friendly     Direct link  

Par2: MSSQL temp Stored Procedures
1998-10-07 -- Scott Ferret
 
The MS SQL Driver has this on by default. To turn it off you need to add to the driver string '/SAVESTOREDPROC=FALSE' for the first file you open. You can put it on all without cost. This is an MSSQL v6.x switch only. In v7 they have improved the database engine a lot and it no longer creates stored procedures for doing queries. The switch is ignored when talking to v7 databases.


Today is November 21, 2024, 8:19 am
This article has been viewed 35287 times.



Back to article list   Search Articles   Add Comment   Printer friendly

Login

User Name:

Password: