So basically what i do is execute the query which is passed as a message.
I don't know if it would be usefull but underneath is a simplified example of the query.
The idea is to update the local table with values from a remote table.
localtable.[namefield] = remotetable.[namefield],
localtable.[imagefield] = remotetable.[imagefield],
(SELECT id, namefield, imagefield FROM [localserver].[localdatabase].[dbo].[localtable] WHERE (id = idvalue)) localtable
OPENQUERY([linkedserver_origin], ''SELECT id, namefield, imagefield FROM [database].[dbo].[remotetable] where (id = idvalue)'') remotetable
ON (localtable.id = remotetable.id)'
It may also be useful to add the Stored Procedures Event Category's SP:StmtStarting and SP:StmtCompleted events to the same profiler trace (and perhaps all events under the Errors and Warnings event category).
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.