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 |
|
ravibabu.j
Starting Member
2 Posts |
 Posted - 2009-09-11 : 05:06:12
|
| Hello,I am implementing transaction in all the stored procedure in SQL Server 2008, but after having discussion with DBA and developer team, there arises a controversy that,where to implement the transaction, ie in Database or in front end codes.(This is a web Application in VB.NET)I want to know - Where is best to implement the transaction and what is the reason for that.Thanks in Advance,Ravi |
|
|
Sachin.Nand
2937 Posts |
Posted - 2009-09-11 : 07:18:23
|
| Let me guess the DBA must hv said in the SP's while the developers wanted it in the front end.Well I dont think there is a straightforward answer for that.It all depends on the situation.Please correct me if I am wrong.PBUH |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-13 : 13:01:06
|
| usually you use explicit transactions when you want a particular group of operations to take place in atomic manner (either full complete or dont do anything at all). |
|
|
|
|
|
|
Transaction