Post reply

SQL 2008 Database triggers

  • December 28, 2009 at 12:46 pm

    #214994

    I go into the database, Programability, Database Triggers and click on the + sign and nothing is there. I know I created them because when I try and recreate them it says they are there. I use another tool and they show up so why won't they show up in Management Studio? This is SQL 2008 SP1 64 Bit on Win2008.

  • December 28, 2009 at 1:13 pm

    #1096805

    What kind of triggers are you talking about?

    A DML trigger (insert/update/delete) will be in the triggers folder under the table that it's created on.

    A database-scoped DDL trigger will be in the Programmability -> Database triggers under the database that they're created in

    A server-scoped DDL trigger will be under Server Object -> Triggers

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 28, 2009 at 1:19 pm

    #1096808

    Yes you ARE correct. I had a brain cramp. Thanks for correcting me.

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

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