Logged vs. Unlogged Modifications

An application can request that the SQL Server Native Client 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

Managing Text and Image Columns