Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

More questions on triggers

From Dom <dolivastro@gmail.com>
Newsgroups comp.databases.ms-sqlserver
Subject More questions on triggers
Date 2011-04-27 06:02 -0700
Organization http://groups.google.com
Message-ID <873a9524-fb27-434b-bfd4-57616cfbec4b@w36g2000vbi.googlegroups.com> (permalink)

Show all headers | View raw

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.

2.  Is there a GUI to create a trigger, like there is to create a
table?  I've been using straight SQL for this.

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.

Thanks, Dom

Back to comp.databases.ms-sqlserver | Previous | Next — 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