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

Re: More questions on triggers

From	Dom <dolivastro@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: More questions on triggers
Date	2011-04-27 07:44 -0700
Organization	http://groups.google.com
Message-ID	<630eb9ad-0b81-4e42-bcba-bc8c05e46853@27g2000yqv.googlegroups.com> (permalink)
References	<873a9524-fb27-434b-bfd4-57616cfbec4b@w36g2000vbi.googlegroups.com> <ip9902$8gk$2@dont-email.me> <4db82b51$0$41117$e4fe514c@news.xs4all.nl>

Show all headers | View raw

On Apr 27, 10:41 am, Henk van den Berg <hvandenb...@xs4all.nl> wrote:
> 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.jpgshows part of my setup.
>
> Best,
> Henk

And that answers my last question!  Thanks to everyone.

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