Post reply

Where to store triggers in the db

  • February 24, 2009 at 2:24 am

    #384001

    Hi

    I wrote few trigger on the database for few tables by right clicking on the table and New trigger through query editor. After executing every trigger, I saved those queries as sql files when it asked me to save in My Documents\SQL Server Management Studio Express\Projects. But when I wanted to look for a trigger it is not available in triggers list but where as when I created an index it is available.

    Can any body help me...Where to store the triggers and how to view and access them.

    (Previously I was working on pgsql where I could see all the triggers are listed under "Triggers" Menu.)

    Thanks

  • February 24, 2009 at 2:32 am

    #949197

    If you created a trigger you will see it under the triggers folder for each table in Object Explorer. Did you refresh object explorer after creating the trigger?

    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

  • February 24, 2009 at 4:14 am

    #949228

    Hey Gail Shaw,,

    thanks a lot...

    I could see the triggers after refreshing the object explorer

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

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