Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SP and Transactions

Author  Topic 

LopakaB
Starting Member

22 Posts

Posted - 2012-02-13 : 11:52:41
I have created two stored procedures. The first procedure calls the second or the second can be called by itself. When I begin the first procedure I begin a transaction, start the second procedure and begin a transaction. when the second commits the trans it commits the first. What is a better way of doing this?

Lopaka

X002548
Not Just a Number

15586 Posts

Posted - 2012-02-13 : 11:56:00
You sure about that?

http://msdn.microsoft.com/en-us/library/ms189336(v=sql.90).aspx



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page
   

- Advertisement -