404932bf   
   From: esquel@sommarskog.se   
      
   Mounilk (mounilkadakia@hotmail.com) writes:   
   > I have a linked server to an Oracle db and I want to disable a trigger   
   > before I update a record.   
      
   Then you need to ask in an Oracle newsgroup how to do that. Once you   
   have the command, you can do:   
      
     EXEC ('') AT linkedserver   
      
   > 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   
      
   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@sommarskog.se   
      
   Books Online for SQL Server 2005 at   
   http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx   
   Books Online for SQL Server 2000 at   
   http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)