hey guys,
ok, heres my problem. I have a view that has an instead-of insert and instead-of update trigger on it. This works fine if I'm directly connected to the server. I can open up query analyser and call
update view1
set column1 = 'data1'
where columnid = 1
and it works just fine.
The problem comes up when I'm on another server that has the first server registered as a linked server. In this case, I try this query:
update server1.dbo.view1
set column1 = 'data1'
where columnid = 1
and i get the following error messages:
Server: Msg 8180, Level 16, State 1, Line 1
Statement(s) could not be prepared.
Server: Msg 4422, Level 16, State 1, Line 1
View 'ookprint.dbo.qryNaitAccessBus_tblUser' has an INSTEAD OF UPDATE trigger and cannot be a target of an UPDATE FROM statement.
can't figure this one out. Is it trying to do all the preprocessing on the computer i'm running the query on, and doesn't have access to the trigger or something? do updates with linked servers create entries in a temp table and then do an UPDATE FROM call?
Help!
Cheyney
ok, heres my problem. I have a view that has an instead-of insert and instead-of update trigger on it. This works fine if I'm directly connected to the server. I can open up query analyser and call
update view1
set column1 = 'data1'
where columnid = 1
and it works just fine.
The problem comes up when I'm on another server that has the first server registered as a linked server. In this case, I try this query:
update server1.dbo.view1
set column1 = 'data1'
where columnid = 1
and i get the following error messages:
Server: Msg 8180, Level 16, State 1, Line 1
Statement(s) could not be prepared.
Server: Msg 4422, Level 16, State 1, Line 1
View 'ookprint.dbo.qryNaitAccessBus_tblUser' has an INSTEAD OF UPDATE trigger and cannot be a target of an UPDATE FROM statement.
can't figure this one out. Is it trying to do all the preprocessing on the computer i'm running the query on, and doesn't have access to the trigger or something? do updates with linked servers create entries in a temp table and then do an UPDATE FROM call?
Help!
Cheyney
