home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,578 of 19,505   
   Gene Wirchenko to john.lutheran@gmail.com   
   Re: Trigger help   
   04 Apr 12 14:58:24   
   
   11d2f940   
   From: genew@ocis.net   
      
   On Wed, 4 Apr 2012 07:05:17 -0700 (PDT), Johnnyb   
    wrote:   
      
   [snip]   
      
   >It stops the replication. What am I doing wrong?   
      
        I do not know quite enough to be sure, but I believe that your   
   trigger's insert is replacing the insert/update.  I believe you need   
   the magic word "AFTER":   
      
   CREATE TRIGGER   
       [dbo].[880IOT]   
   ON   
       [dbo].[logfile0]   
   after INSERT, UPDATE   
   AS   
   ...   
      
   [snip]   
      
   Sioncerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca