Solved

How do i see /manage what triggers are associated to a database?

Posted on 2007-12-06
3
131 Views
Last Modified: 2010-03-19
How do i see /manage what triggers are associated to a database? i know theres a section in Programmability -> Database Triggers.

But even though i've created two i can see them when refreshed?
0
Comment
Question by:paulCardiff
  • 2
3 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 20419969
SELECT * FROM sysobjects WHERE TYPE ='tr'
0
 

Author Comment

by:paulCardiff
ID: 20420000
Is there a way in managment studio to do this i.e. Programmability -> Database Triggers.?
0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 20420157
Programmability -> Database-> tables -> urLocalTable-> Triggers
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

831 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