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

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

Re: More questions on triggers

Show all headers | 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