Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: "Bob Barrows" Newsgroups: comp.databases.ms-sqlserver Subject: Re: More questions on triggers Date: Wed, 27 Apr 2011 10:24:14 -0400 Organization: A noiseless patient Spider Lines: 26 Message-ID: References: <873a9524-fb27-434b-bfd4-57616cfbec4b@w36g2000vbi.googlegroups.com> Injection-Date: Wed, 27 Apr 2011 14:25:06 +0000 (UTC) Injection-Info: mx01.eternal-september.org; posting-host="NUmboHSNYG4cX5Ys9j8TNw"; logging-data="8724"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19tbJpC0lsgjNev7GyX0igw+9iNzn3GBL8=" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.2001 X-Antivirus-Status: Clean X-Newsreader: Microsoft Outlook Express 6.00.2800.2001 X-Antivirus: avast! (VPS 110427-0, 04/27/2011), Outbound message Cancel-Lock: sha1:U2SnDVPDDyI2p3ZuS2EiDJvaU1E= X-Priority: 3 X-MSMail-Priority: Normal Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:233 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