151c73a4   
   From: hvandenberg@xs4all.nl   
      
   On 27-04-2011 15:02, Dom wrote:   
   > 1.  Where are triggers shown on the Object Explorer in SSMS?  I   
   > thought they would be listed under "Programmability ... Database   
   > Triggers" but they aren't there.   
   That's where they are listed. Did you d a refresh after creating the   
   trigger?   
   >   
   > 2.  Is there a GUI to create a trigger, like there is to create a   
   > table?  I've been using straight SQL for this.   
   Don't think so, but using straight SQL for this is a good idea anyway.   
   >   
   > 3.  How do you modify a trigger?  I've been using sp_helptrigger to   
   > get the trigger name (since I can't find it anywhere in SSMS), and   
   > then sp_helptext to get the SQL of the trigger.   
      
   alter trigger  ON DATABASE FOR  AS   
   print 'this is a database trigger'   
      
   See also my answer to 1.   
      
      
   >   
   > Thanks, Dom   
      
      
   Best,   
   Henk   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)