Solved

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

Posted on 2007-12-06
3
132 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

Title # Comments Views Activity
2 comma seperated list - SQL Server 12 42
ms sql + top 1 for each customer 3 56
Delete from table 6 47
why sql server only update some statistics in the database ? 3 32
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…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

790 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