Linked Server Question
I am attempting to populate a table on a linked server with values
from my local sql server table's trigger. I am able to manually select, insert, update, delete rows from query analyzer the linked db table but when I execute the trigger on my local table the server will hang indefinately. My insert statement within the local table's Update trigger goes like this:
insert linkedserver.linkeddb.owner.linkedtable(OrderTotal , Account)
select OrderTotal, Account
from inserted
Why does the server hang when executing this insert statement?
|
