Ever Lost Your Triggers

Home » Blog article: Ever Lost Your Triggers

Ever Lost Your Triggers

Ever have an issue locating your triggers w/ MS SQL Server Management Studio or forget what triggers are running? Well this snippet should lend you a hand:

USE [dbname]
SELECT *
FROM sys.triggers
WHERE is_disabled = 0 -- Enabled
ORDER BY [Name];
GO

This entry was posted on Saturday, December 13th, 2008 at 8:26 am and is filed under Databases, SQL Server 2005. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

blog comments powered by Disqus

Thats me above wearing one of my favorite Adidas track jackets. This is my home on the web showcasing some of my work over the past few years in the Interactive Marketing/Advertising field. In addition to my portfolio you'll find some personal information about me as well as some ramblings on some of the research and development I participate in. Enjoy!

Recent Tweets

keep calm. carry on. 2 hrs ago
@semaphoria ps really enjoy the recent fast company articles on small society cc @ravenme in reply to semaphoria 16 hrs ago
@semaphoria forgiven :) i'm planning a trip to #pdx i should check with you offline to make sure you will be in town. in reply to semaphoria 16 hrs ago
More updates...

Ever Lost Your Triggers

Recent Tweets

Browse by Category

Archives

Latest Work

Recent Posts

Recent Comments

Links