Where''s my TRIGGER gone?

• Tim Morrison

  SSC Eights!

  Points: 894

  More actions

  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

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  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]

• Tim Morrison

  SSC Eights!

  Points: 894

  More actions

  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....