I am trying to have a trigger update a linked server.



I am able to run routine DML on the linked server like:



Select * from linkedserver1.Database.owner.Table



and



Update linkedserver1.Database.owner.Table

set Col1 = 'Yes'

where Col2 = 'ABC'



But when I attempt to include an update statement in a trigger on the
local

server/db, the server will just hang indefinitely.



Does anyone know what is going on here?







Sincerely,



Justin














MS Sql Server LazyDBA home page