Fyi - you probably don't need to wrap the table mod in a transaction anyway. When you're running a single update, insert, etc... I don't think there's an advantage to putting it in a transaction. If you're running multiple queries a transaction will make execution faster (eg: if you're inserting 1,000 records in a loop), or if you're performing a cascading delete on multiple tables & you need to back out the entire process if it fails at any stage a transaction will do that.
- Colin.