Solved

Find the Triggers in the SQL server

Posted on 2012-03-16
3
203 Views
Last Modified: 2012-06-27
Hello,

I have created a trigger in my database and is running. I can only find it using Select *
from sys.triggers. Why it does not appear under Programmability/Database Triggers?
Also, how can I edit the systax of the trigger?
0
Comment
Question by:MissNicola
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
winston33 earned 225 total points
ID: 37731670
It is likely that you have a trigger on the table itself, so you can find each trigger by browsing to the table, expanding the table and then expanding the Triggers folder. If you right-click/Modify the trigger, you can update the syntax.
0
 

Author Comment

by:MissNicola
ID: 37731701
Thanks, I found it. How can I add a trigger to be shown under programmability?
0
 
LVL 2

Expert Comment

by:winston33
ID: 37731710
This is an area only for database-level triggers (e.g. DROP TABLE, ALTER TABLE, etc.). If you want to run a trigger for those types of events, right-click/New Database Trigger on the Programmability folder.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

738 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