Very Computer

You wrap them in a warm fuzzy blanket.. ;)
JK

Use the OLEDB provider, ADO and have fun.
Connection.BeginTrans
Connection.CommitTrans

--
Will Rickards

But even OLEDB cannot change the fact that SQL Server doesn't support nested
transactions...

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com

U Sure?
Books online seems to indicate that it does.
I believe I used nested transactions before, though I could be wrong.
Memory is not my strongpoint.

Are you referring to the fact that you can nest transactions but a commit
commits the whole thing, not just the nested transaction?  And you can only rollback the
outet transaction?

--
Will Rickards

You can nest BEGIN TRAN, but that doesn't give you the semantics of nested
transactions ("sub-transactions").
A COMMIT will only decrease nestlevel.
ROLLBACK will terminate the transaction (no matter how deep you are).

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com

Quote:> U Sure?
> Books online seems to indicate that it does.
> I believe I used nested transactions before, though I could be wrong.
> Memory is not my strongpoint.

> Are you referring to the fact that you can nest transactions but a commit
> commits the whole thing, not just the nested transaction?  And you can only rollback
the
> outet transaction?

> --
> Will Rickards