SQL 2005 Service Pack 2 Distributed Transactions and mirroring RRS feed

  • Question

  • Is it possible to use DTC (or cross database queries) with mirroring on SQL 2005 Service Pack 2?




    Monday, June 4, 2007 9:42 AM

All replies

  • Do you mean query the partner that is in the mirror role ? If so, that's not possible because you can't connect to a database that acting in a mirror role.
    Tuesday, June 5, 2007 3:19 AM
  • The documented limitations on using DTC with mirroring have not changed for Service Pack 2.


    Tuesday, June 5, 2007 4:06 PM