Q

Equivalent of Oracle's 'autonomous' transactions

Does "autonomous" transaction (Oracle terminology) exist in MS SQL 2000? How can I log some actions during transaction into table without losing this information when this transaction is rolled back.

Yes, there is a concept such as this in SQL Server. Look under savepoints in Books Online.

 

For More Information

This was first published in October 2003

Dig Deeper

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close