Tuesday, December 30, 2014

Change tracking version

Erland,


you will know :)


I'm using this tracking version to call some procedure on my remote server:



EXEC('[dbo].[my_procedure] ?', @change_tracking_version) AT [myRemoteServer]

Inside this procedure on remote server I'm reading back one table which is on local server:



INSERT INTO #tmp_category ( code )
SELECT code FROM OPENROWSET('SQLNCLI', 'Server=myServer;Trusted_Connection=yes;', 'set fmtonly off SELECT * FROM myDb.dbo.item_category WHERE transfer=0')

But I get an error:

"Access to the remote server is denied because no login-mapping exists."


How can I solve this issue with retaining trusted connection - since I don't won't to write user name and password into the code.


No comments:

Post a Comment