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

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 06:35 -0700
Organization	http://groups.google.com
Message-ID	<96e02e35-f19e-481f-a9fa-d18a5a14fdd2@s4g2000yql.googlegroups.com> (permalink)
References	<873a9524-fb27-434b-bfd4-57616cfbec4b@w36g2000vbi.googlegroups.com> <4db8174a$0$41114$e4fe514c@news.xs4all.nl> <d04bfedb-941f-4ae7-9118-f096929457e3@p13g2000yqh.googlegroups.com> <4db81abc$0$41113$e4fe514c@news.xs4all.nl> <03d8257b-35c6-4b32-b847-b93f35a47abd@w10g2000yqa.googlegroups.com>

Show all headers | View raw

On Apr 27, 9:34 am, Dom <dolivas...@gmail.com> wrote:
> On Apr 27, 9:30 am, Henk van den Berg <hvandenb...@xs4all.nl> wrote:
>
> > On 27-04-2011 15:26, Dom wrote:
>
> > > Yes, I did a refresh on the "Database Triggers", and each of the
> > > higher nodes, ("Programmability", etc.).  Nothing shows up there.  I
> > > guess of all my questions, you've answered all, but I still don't see
> > > a list of the triggers.  Any ideas?
>
> > Just to cover all the bases: when you close SSMS and then re-open it, do
> > they show up?
>
> Nope.  I'm really stumped on this.

Also, as I've indicated before, sp_helptrigger, and sp_helptext work
as expected, so they are getting stored properly.

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