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.
| Author |
Topic |
|
gatonegro
Starting Member
4 Posts |
 Posted - 2004-09-23 : 10:00:20
|
| Hi there everybody !!!Y have one cuestion, if i call from VB 2 SP's ....Did i have some way to begin the transaction inside the first SP and commit the transaction when i call the last one ? this is because i don't want to begin and end the transaction from VB, and don't want the first SP to call the another one, but call both from V.B !!!ANY IDEAS ? |
|
|
DustinMichaels
Constraint Violating Yak Guru
464 Posts |
Posted - 2004-09-23 : 10:19:19
|
| Perhaps you could just make a stored procedure that 1)begins a transaction 2)calls stored procedure 1 and stored procedure 2 3)then commits the transaction |
 |
|
|
|
|
|
Begin Transaction in one SP and Commit in another!