Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Logged vs. Unlogged Modifications

SQL Server 2000

An application can request that the Microsoft® SQL Server™ ODBC driver not log text, ntext, and image modifications. Care should be used with this option, however. It should be used only for those situations where the text, ntext, or image data is not critical and data owners are willing to trade off the ability to recover data for higher performance.

The logging of text, ntext, and image modifications is controlled by calling SQLSetStmtAttr with the Attribute parameter set to SQL_SOPT_SS_
TEXTPTR_LOGGING and ValuePtr set to either SQL_TL_ON or SQL_TL_OFF.

See Also

SQLSetStmtAttr

Show:
© 2015 Microsoft