| Navigation: SQL Drivers > MSSQL Accelerator >====== SAVESTOREDPROC (MSSQL Accelerator) ====== |    |
DRIVER('MSSQL', '/SAVESTOREDPROC= TRUE | FALSE ' )
[ SaveProc“ = ] SEND(file, '/SAVESTOREDPROC [ = TRUE | FALSE ]' )
When the MSSQL Accelerator sends SQL statements to the MSSQL server, the server creates a temporary stored procedure on the server and executes it. The stored procedure is reused on subsequent executions of the same SQL statement. By default, (SAVESTOREDPROC=TRUE), and these stored procedures remain on the server until connection to the server is dropped.
To remove the procedures as soon as possible, set SAVESTOREDPROC=FALSE. Note that this is something done by MSSQL and may vary with different versions of MSSQL. For complete details on how MSSQL optimizes your code please refer to the documentation of the specific version of MSSQL you are using in the section dealing with calling MSSQL via ODBC.