Solved

Find the Triggers in the SQL server

Posted on 2012-03-16
3
194 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
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
winston33 earned 225 total points
Comment Utility
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
Comment Utility
Thanks, I found it. How can I add a trigger to be shown under programmability?
0
 
LVL 2

Expert Comment

by:winston33
Comment Utility
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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
This video discusses moving either the default database or any database to a new volume.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

771 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

12 Experts available now in Live!

Get 1:1 Help Now