database triggers folder

Posted on 2007-10-01
Last Modified: 2010-03-19
why is it that in sql server 2005 management express when i click the database triggers folder under my database, it always finds nothing.  I've added triggers to it, and now I want to alter them.  I right click the folder and it doesn't give me anything under the context menu other than refresh.  Shouldn't it have a "new trigger" or something also.  

How do I alter my triggers if it isn't going to show me what triggers I have.  Is this a bug, has anyone else noticed this??
Question by:picsnet
    LVL 5

    Accepted Solution

    The triggers usually show up under the table that are dependent on them.  Expand a table and then the tables trigger folder and they should be there.  If they aren't then you may have a problem with management studio.
    LVL 1

    Author Comment

    i'll be damned...
    LVL 27

    Expert Comment

    There are two types of triggers in SQL 2005.

    The DML triggers are tied to a particular table. These are the INSERT, UPDATE, or DELETE triggers that you mention.

    DDL triggers, like the ones that you would use to audit database level changes, are kept in the Database Triggers folder under Programmibility.
    LVL 1

    Author Comment

    thanks, that clears things up a bit

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now