INF: -T3640 Flag May Block Updates to an ODBC Application (113674)
The information in this article applies to:
- Microsoft SQL Server 4.2x
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
- Microsoft ODBC Driver for SQL Server 1.0
This article was previously published under Q113674 SUMMARY
Microsoft SQL Server version 4.21 (and later versions) provides a -T3640
flag that provides stored procedure performance enhancements. The flag
optimizes stored procedure execution time because it suppresses the sending
of individual statement completion information, which reduces network
traffic and has a significant effect on stored procedure execution time,
especially in wide area network (WAN) environments.
This information is not required by SQL Server/DB-Library (DB-Lib)
applications but may affect some ODBC applications. When SQL Server is
running with this flag enabled, an ODBC-enabled application using Microsoft
ODBC SQL Server driver to attempt to process update queries against tables
in SQL Server may fail because SQL Server is no longer sending rows
affected information required by some ODBC applications, such as Microsoft
Access for Windows.
Modification Type: | Major | Last Reviewed: | 12/3/2003 |
---|
Keywords: | kbinterop KB113674 |
---|
|