151c73a4   
   From: reb01501@NOyahooSPAM.com   
      
   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.   
      
   No, they're not there. They are listed within each table node, along with   
   the columns,keys, constraints and indexes.   
   I guess the thinking is that they are table objects, not database objects,   
   so just as you don't have a node to show all the indexes in the database,   
   neither do you have a node to show all triggers. You have to expand the   
   individual table nodes.   
   >   
   > 2.  Is there a GUI to create a trigger, like there is to create a   
   > table?  I've been using straight SQL for this.   
      
   No. If you right-click a trigger  in the Triggers node and select New   
   Trigger, it will open a query window with the script from a trigger-creation   
   template.   
   >   
   > 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.   
   >   
   Right-click a trigger in the Triggers node and select Modify   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)