Browse by Tags

All Tags » linked server (RSS)
22 November 2009 22:02

DATA ACCESS setting on local server

When you look at the sys.servers catalog view, you will see list of linked servers defined on the server plus one additional row for the server itself. You can distinguish the local server from linked servers by column server_id, which in case of local...
Posted by Piotr Rodak | 4 comment(s)
Filed under: , , , ,
29 October 2007 20:37

distributed transactions and triggers

Last week I came across an interesting issue. If you have a FOR INSERT trigger on a table and you want to store some information on a linked server, the transaction the trigger is running within is automatically expanded to distributed mode. This creates...
Posted by Piotr Rodak | with no comments
Filed under: , ,