151c73a4   
   From: esquel@sommarskog.se   
      
   Dom (dolivastro@gmail.com) writes:   
   > 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.   
      
   They are shown under the table they belong to. The node under   
   Programmability is for DDL trggiers.   
      
   > 2.  Is there a GUI to create a trigger, like there is to create a   
   > table?  I've been using straight SQL for this.   
      
   That's the way to do it. For both tables and triggers. The Table Designer is   
   a piece of crap.   
      
   > 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.   
      
   Like any other source code, you should keep your SQL code under version   
   control. In that case it's simple. You go to your version-control system   
   and check it out. Yeah, you can script things from the database, but   
   that is like disassembling your object files to edit your C# code.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)