GTR (3/26/2010)
Check this, it should answer your questionhttp://msdn.microsoft.com/en-us/library/ms189336(SQL.90).aspx
This method would allow the OP to place a transaction in both stored procedures (thus nest the transactions).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events