Logged vs. Unlogged Modifications
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.