In SQL Server, I have a stored procedure that returns some sensitive data to the client, and logs that fact into a log table. The stored procedure is executed in a transaction controlled by the client, so the client can rollback the transaction after the procedure has executed.

How do I ensure that the row created in the log table survives even if the client rolls-back the transaction?