Hi,
I have a linked server to an Oracle db and I want to disable a trigger
before I update a record.

I am able to select data from the table using the syntax Select * from
[LinkedServer]..[Schema].[TableName]; but when I try to disable the
trigger, I am getting error.

I tried the following scripts:

Script1:
ALTER TRIGGER [LinkedServer]..[Schema].TriggerName DISABLE
Error:
The object name ''[LinkedServer]..[Schema].TriggerName" contains more
than the maximum number of prefixes. The maximum is 2

Script2:
ALTER TABLE [LinkedServer]..[Schema].[TableName] DISABLE TRIGGER
TriggerName
Error:
Cannot find the object "[LinkedServer]..[Schema].[TableName]" because
it does not exist or you do not have permissions.


Any help is greatly appreciated

Cheers,
Mounilk

Mounilk (mounilkadakia (AT) hotmail (DOT) com) writes:
Then you need to ask in an Oracle newsgroup how to do that. Once you
have the command, you can do:

EXEC ('<the ORACLE command goes here>') AT linkedserver

This means that you can use ALTER TRIGGER to disable a trigger on a linked
server. Generally, you cannot use four-part notation in DDL commands.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx