Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
What's happened to SQL_PRESERVE_CURSORS in SQL 7.0?
Neil Pike
October 20, 1999
1 Min Read
A. It was broken/changed from 6.5 in 7.0.
SQL 6.5 - SQL_PRESERVE_CURSORS apply to both COMMIT_BEHAVIOR and ROLLBACK_BEHAVIOR
SQL 7.0 - SQL_PRESERVE_CURSORS only apply to COMMIT_BEHAVIOR
SQL 7.0 SP1 - As 6.5
SQL 7.0 SP1 with -T7525 traceflag - As per 7.0
Look up:
See http://support.microsoft.com/support/kb/articles/Q199/2/94.ASP for more info
About the Author
You May Also Like
.png?width=700&auto=webp&quality=80&disable=upscale)