In Chapter 6, “SQL Statements,” “Set statement [T-SQL],” OFF is not an option for CLOSE_ON_ENDTRANS and has been removed from table 6-14.
In the subsequent bulleted list, CLOSE_ON_ENDTRANS should read as follows:
SET CLOSE_ON_ENDTRANS { ON } When CLOSE_ON_ENDTRANS is set to ON (the default and only allowable value), cursors are closed at the end of a transaction. With the option set ON, CLOSE_ON_ENDTRANS provides Transact-SQL compatible behavior.