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!

**Disclaimer - The postings on this site are my own and do not necessarily represent the positions, strategies or opinions of George P. Johnson or Juxt Interactive.

Recent Tweets

@kim Einstein on the Beach http://j.mp/alSaPb in reply to kim 14 hrs ago
Interesting statistics on which social gaming companies are hiring & which are interested in smartphones: http://j.mp/9g7JgI by @dliman 17 hrs ago
What to expect on the HTC Droid Incredible running Flash 10.1 > http://j.mp/csQ2Or [video] 17 hrs ago
More updates...

Ever Lost Your Triggers

Recent Tweets

Browse by Category

Archives

Latest Work

Recent Posts

Recent Comments

Links