Thank you, both for your help. I think perhaps I was trying to do too much for my first attempt at this!

Here is how I've changed the code and...

I'd love to Bhuvnesh but I'm using SQL 2000 🙁

Thanks, Gail. In a way it's a comfort to know its not just me being a pleb with this. It sounded so simple at the start!!!

I have just...

GilaMonster (1/25/2013)

---

Nested transactions are a lie (and a major pain)

The rollback in the inner procedure rolls back all the way to the first begin tran

Hence you enter the inner proc...