AUTOMONOUS TRANSACTION in sql server 2000


M

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
 
Ad

Advertisements

M

[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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top