Viewing 2 posts - 1 through 2 (of 2 total)
I absolutely concur with Noel. If the DTC service is not running on remote server, or DTC is not configured correctly, your OPENDATASOURCE queries will not run on those servers. ...
July 13, 2007 at 6:32 am
#719262
USE
AdventureWorks
GO
CREATE
PROCEDURE udp_Order
@tablename
varchar(100)
AS
EXEC('SELECT...
November 15, 2005 at 5:25 pm
#604065