Distributed transactions are one of the more powerful and important functions within SQL Server. A distributed transaction is just like any other transaction within the SQL Server database, with a ...

Is it possible to use linked services in MSSQL Server and execute queries if the Distributed Transaction Coordinator is not enabled?<BR><BR><BR><BR>Maybe this should be in the NT forum, but I thought ...

Q: We use a lot of distributed transactions and we are now investigating database mirroring to provide high availability to one of our critical databases. During our testing, we discovered that ...

Is there any reason you would NOT want this service running and you would NOT want to allow network access/communication?<BR><BR>This would be on Windows Server 2003 with the current updates (as ...