HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Does openquery use distributed transactions?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
openquerydistributeddoestransactionsuse

Problem

Does openquery in SQL Server 2005 use distributed transactions? If so, in which cases does it?

Solution

It can use distributed transactions if the OLE-DB provider supports it. Otherwise it tries to limit the commands to read-only operations.

Reference: http://msdn.microsoft.com/en-us/library/ms177403%28v=sql.90%29.aspx

Context

StackExchange Database Administrators Q#46531, answer score: 2

Revisions (0)

No revisions yet.