Perform the following task:

ONE: Run this in QA and check to make sure that Server1 has srvid = 0

use master

go

select * from sysservers

go

TWO: If ONE did not give you srvid...

I believe the MS DTC is use when you want to run a distributed query/view among multiple SQL Servers. However MTS is used when you developing a 3-tier application, in...

I took a look at the knowledge Base Article but it seems to be refering to Database Upgrade process from SQL6 to SQL7. I guess my main question is, does...