Post reply

Where''s my TRIGGER gone?

  • January 5, 2006 at 7:03 am

    #364624

    Hello people,

    I've been exploring my shiny new SQL Server 2005 DEVELOPER Edition and I thought I was doing OK.  I created a TRIGGER on a table that used SP_SEND_DBMAIL to send me an email on INSERT - all works lovely, except that I can't now see that I have got a trigger, it's not visible anywhere, yet I know it's there because it sends me an email....

    Any ideas? I'm looking at MY_DB/PROGRAMMABILITY/DATABASE TRIGGERS folder in OBJECT EXPLORER. Initially it has a + sign next to it indicating something within, but it disappears and the only option I have is REFRESH, no option to create a NEW TRIGGER.

    Cheers to all,

    Tim

  • January 5, 2006 at 7:29 am

    #612881

    Tim,

    look under Your_Db\Tables\tablename\triggers

    The other folder database triggers  is only for trigger on the database level like ddl triggers.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • January 6, 2006 at 5:40 am

    #613172

    Cheers Markus! I'll get used to it eventually.... still having trouble working my way round BOL....

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply