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 |
|
Munchkin
Starting Member
1 Post |
 Posted - 2002-05-30 : 07:19:59
|
| Can anyone tell me if it is possible to wrap up many whole stored procedures in a transaction and if so will they roll back to the start if an error occurs. Basically we need to know that if an eeror occured, it will not comit any of the data |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-05-30 : 07:45:05
|
| You can open a transaction and leave it open for the rest of eternity, if that suits you. Implicit transactions are based on a 'batch' so if you exec multiple procs in the same batch, they will implicitly be included in the same transaction.Data is not commited until a) the explicit transaction is committed or b) the batch completes.<O> |
 |
|
|
yoursfriend
Starting Member
5 Posts |
Posted - 2002-05-30 : 08:30:20
|
Hi Munchkin,quote:
You can open a transaction and leave it open for the rest of eternity, if that suits you. Implicit transactions are based on a 'batch' so if you exec multiple procs in the same batch, they will implicitly be included in the same transaction. Data is not commited until a) the explicit transaction is committed or b) the batch completes.
Yes. its absolutely correct. try to do it. It will solve your problems. |
|
|
|
|
|
|
Transactions in Stored Procedures