AUTOMONOUS TRANSACTION in sql server 2000

[mr.nitinjain]

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

 

[[MVP] S.Clark]

First, this forum is for Microsoft Access Queries, so you're in the wrong
pond, but it is still the right kind of water. Check in one of the SQL
Server newsgroups for a better/faster answer. Also, the Books Online(BOL)
help file that installs with Enterprise Manager is pretty comprehensive.

I think that you would somehow have to have nested transactions, or perform
a committrans, but am not versed enough in the art.