database triggers folder

Posted on 2007-10-01
Medium Priority
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
  • 2

Accepted Solution

gigglick earned 2000 total points
ID: 19993594
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.

Author Comment

ID: 19993631
i'll be damned...
LVL 27

Expert Comment

ID: 19993648
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.

Author Comment

ID: 19993706
thanks, that clears things up a bit

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

850 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