Microsoft SQL Server 2005: BEGIN TRAN - ROLLBACK TRAN and Linked Server Tables

Do SQL Transactions work for the LINKED SERVER tables the same way they work for native  tables?

BEGIN TRAN 
 
DELETE FROMLINKEDSERVER.catalog.dbo.table 
 
ROLLBACKTRAN

Open in new window

yasuakikudoAsked:
Who is Participating?
 
appariConnect With a Mentor Commented:
for more info on distributed transactions check
http://msdn.microsoft.com/en-us/library/ms188386.aspx
0
 
appariCommented:
you have to use
BEGIN DISTRIBUTED TRANSACTION;
instead of Begin Tran
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.