If you nest transactions, and you commit the inside transaction, then you rollback the primary transaction, does it also rollback the nested one which was comitted???

Thanks...

We are basically wondering how our newid procedure that has a transaction will be handled.

BOb