AUTONOMOUS TRANSACTION in SQL server 2000



Hi members,

I just need to know is there any mechanism for autonomous transactions
in SQL server 2000 as I have to maintain a log inside a transaction,

If I have autonomous transaction, all the entries in my LOG table wont
be rolled back even if the transaction is ROLLED back.
This concept works on ORACLE. I want to know if there is something
similar of this type in MS SQL..

Thanks

Nitin Jain

.