Groups > comp.databases.ms-sqlserver > #233

Re: More questions on triggers

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" <reb01501@NOyahooSPAM.com>
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	<ip9902$8gk$2@dont-email.me> (permalink)
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

Show key headers only | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

More questions on triggers Dom <dolivastro@gmail.com> - 2011-04-27 06:02 -0700
  Re: More questions on triggers Henk van den Berg <hvandenberg@xs4all.nl> - 2011-04-27 15:16 +0200
    Re: More questions on triggers Dom <dolivastro@gmail.com> - 2011-04-27 06:26 -0700
      Re: More questions on triggers Henk van den Berg <hvandenberg@xs4all.nl> - 2011-04-27 15:30 +0200
        Re: More questions on triggers Dom <dolivastro@gmail.com> - 2011-04-27 06:34 -0700
          Re: More questions on triggers Dom <dolivastro@gmail.com> - 2011-04-27 06:35 -0700
          Re: More questions on triggers Henk van den Berg <hvandenberg@xs4all.nl> - 2011-04-27 15:35 +0200
  Re: More questions on triggers Henk van den Berg <hvandenberg@xs4all.nl> - 2011-04-27 15:27 +0200
  Re: More questions on triggers Henk van den Berg <hvandenberg@xs4all.nl> - 2011-04-27 15:27 +0200
  Re: More questions on triggers "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-04-27 10:24 -0400
    Re: More questions on triggers Dom <dolivastro@gmail.com> - 2011-04-27 07:36 -0700
    Re: More questions on triggers Henk van den Berg <hvandenberg@xs4all.nl> - 2011-04-27 16:41 +0200
      Re: More questions on triggers Dom <dolivastro@gmail.com> - 2011-04-27 07:44 -0700
        Re: More questions on triggers Henk van den Berg <hvandenberg@xs4all.nl> - 2011-04-27 18:48 +0200
  Re: More questions on triggers Erland Sommarskog <esquel@sommarskog.se> - 2011-04-28 00:02 +0200

csiph-web