<div>
SELECT * FROM sysobjects WHERE TYPE ='tr'
</div>


SELECT * FROM sysobjects WHERE TYPE ='tr'

<div>
Is there a way in managment studio to do this i.e. Programmability -&gt; Database Triggers.?<br />

</div>


Is there a way in managment studio to do this i.e. Programmability -> Database Triggers.?


<div>
<div class="content wysiwyg-content">
How do i see /manage what triggers are associated to a database? i know theres a section in Programmability -&gt; Database Triggers.<br />
<br />
But even though i've created two i can see them when refreshed? 
</div>
</div>


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? 

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

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.