Re: How to implement nested transaction



"Jack Zhong" <nospam_jz@xxxxxxxx> wrote in message
news:483332a2@xxxxxxxxxxxxxxxxxxxxxxxxx

Any instruction would be greatly appreciated.

Short answer, MSSQL does not support nested transactions in the way you (and
probably most people) think it should.

Long answer, MSSQL's Books Online has an example of what it considers nested
transactions and you'll be able to find a lot more online (Google).

Good luck,
krf


.