Even if you don´t need it, is it possible to set up a linked server between two SQL-db on the same server.
I have a linked server wich I can use from Query analyzer to get information from the other db BUT when I try to use it from an application I get the message "Rollback transaction request has no corresponding Begin transaction"
Originally posted by mux666
Ok. What is it and how do I use it?
Distributed transactions span two or more servers known as resource managers. The management of the transaction must be coordinated between the resource managers by a server component called a transaction manager. Microsoft® SQL Server™ can operate as a resource manager in distributed transactions coordinated by transaction managers such as the Microsoft Distributed Transaction Coordinator (MS DTC), or other transaction managers that support the X/Open XA specification for Distributed Transaction Processing. For more information, see the Microsoft Distributed Transaction Coordinator documentation.