Eirikur Eiriksson (12/27/2015)
if you need functionality outside the ACID then use Jeff's suggestion and output the log to a file,
While I totally agree with a file approach I must note that a file is just another type of a remote server. If you save your log records on another instance of SQL Server (or any other DB engine) using an openquery call than they won't be affected by a rollback.
_____________
Code for TallyGenerator