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 |
|
razeena
Yak Posting Veteran
54 Posts |
 Posted - 2011-09-06 : 02:49:31
|
| Hi, If we are doing some sql manipulation(eg:insertion and deletion) on twodatabases on the 'same server,1) which transaction statement is to be used?'Begin transaction or 'begin distributed transaction'2)What is the significance of Distributed Transaction Coordinator in the above process? |
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2011-09-06 : 03:00:37
|
| for manipulation with in a server Begin transaction is enough..If you are querying remote servers using Linked servers. u can use Distributed Transactions. and more over if you use Begin tran on remote servers Distributed Transaction Coordinator will convert Begin transactions transactions in to BEGIN DISTRIBUTED TRANSACTION.Karthikhttp://karthik4identity.blogspot.com/ |
 |
|
|
razeena
Yak Posting Veteran
54 Posts |
Posted - 2011-09-06 : 05:35:57
|
Thanksquote:
Originally posted by karthik_padbanaban
for manipulation with in a server Begin transaction is enough..If you are querying remote servers using Linked servers. u can use Distributed Transactions. and more over if you use Begin tran on remote servers Distributed Transaction Coordinator will convert Begin transactions transactions in to BEGIN DISTRIBUTED TRANSACTION.Karthikhttp://karthik4identity.blogspot.com/
|
|
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2011-09-06 : 06:02:13
|
| WelcomeKarthikhttp://karthik4identity.blogspot.com/ |
|
|
|
|
|
|
Transaction