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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2006-08-29 : 01:21:29
|
| hi friends,is it possible to roll back a transaction here? i heard that it will be possible only if we wrote the code only in certain block.please tell me the block.vinod |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-08-29 : 01:32:12
|
| if you write a code in block of Begin Tran . Rollback Tran then only its possible to Rollback, else its auto commit.Chirag |
 |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2006-08-29 : 01:42:12
|
| You can set how SQL Server performs transactions by default..Out of the box it is auto commit...I'll leave it to you to find outDavidMProduction is just another testing cycle |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2006-08-29 : 02:44:07
|
| thank you David, i got information in BOL |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2006-08-29 : 03:12:29
|
| No problems at all mate!It is good to see people doing there own research.. the best method of learning...DavidMProduction is just another testing cycle |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
is rollback possible?