> What does "Generate Stored Procedure for Prepared Statement" do in the
> SQL Server driver section of the ODBC management of the CF Administrator?
Ken
This is an ODBC feature which applies to the execution of dynamic queries.
WHen you access SQL Server via a low-level database library you have to
PREPARE the statement, BIND the parameters and EXECUTE the statement.
Hence the use of the phrase Prepared Statement.
Presumably this is what happens when you do a CFQUERY.
SQL Server is able to automatically turn a statement into a temporary
stored procedure when you PREPARE it, then run the stored procedure
when you EXECUTE it, then throw it away.
This switch turns off that behaviour.
See
http://support.microsoft.com/support/kb/articles/Q151/5/36.ASP
Nick
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
