Solved

Find the Triggers in the SQL server

Posted on 2012-03-16
3
198 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
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

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…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

803 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