Does openquery in SQL Server 2005 use distributed transactions? If so, in which cases does it?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
It can use distributed transactions if the OLE-DB provider supports it. Otherwise it tries to limit the commands to read-only operations.