• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

Find the Triggers in the SQL server

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
MissNicola
Asked:
MissNicola
  • 2
1 Solution
 
winston33Commented:
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
 
MissNicolaAuthor Commented:
Thanks, I found it. How can I add a trigger to be shown under programmability?
0
 
winston33Commented:
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

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now