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,275 of 19,505   
   Henk van den Berg to Bob Barrows   
   Re: More questions on triggers   
   27 Apr 11 16:41:37   
   
   From: hvandenberg@xs4all.nl   
      
   On 27-04-2011 16:24, Bob Barrows wrote:   
   > 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.   
      
   There's actually two places where you can find triggers.   
   1. DML triggers are located under the Table node   
   2. DDL triggers are located under the Database node   
      
   http://www.hvandenberg.net/SSMSTree.jpg shows part of my setup.   
      
   Best,   
   Henk   
      
   --- 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