In SQL Server 2000 and onwards there are INSTEAD OF triggers that can be used to carry out such tasks. Although these types of triggers can be used in a number of scenarios their primary function is to perform DML operations through such views. This tip shows how to use INSTEAD OF triggers to handle these DML operations on views.  Read more...

Part 2 of MVP Andy Warren's SQL School video on Instead of Triggers.  Read more...

If you have never used an instead of trigger, it's a great mechanism for evading table triggers in certain situations. MVP Andy Warren brings you part one of this SQL School video.  Read more...

Continuing with his series on using auditing information to roll transactions forward or back, David McKinney shows us how to generate audit triggers using XML.  Read more...

Filtering DML statements by loginname , host name or application name   Read more...

Triggers are supposed to fire for every update, but in this video we see how you can bypass a trigger for an update.  Read more...

In this article, Johan Bijnens shows how logon triggers can bite you in the back.  Read more...

One of the things you need to aware of is that if you create a logon trigger and there is some bad code you are going to prevent everyone from logging into your SQL Server, even if you try as "sa" or a member of the sysadmin fixed server role. How do I log on to my SQL Server to fix this trigger?  Read more...

This article by Jack Corbett explains what triggers are, the different types, and how to avoid common mistakes.  Read more...

I want to suppress the trigger from firing for a particular statement while it remains in its normal execution state for any of the other statements. Is there any way this can be done dynamically?  Read more...

Over the years, I have witnessed many developers being confused about when to use data-manipulation language (DML) triggers vs. when to use constraints.  Read more...

When databases suddenly stop working, it can be for a number of different reasons. Human error plays a large part, of course, and the DBA needs to know what these various humans are up to. DDL triggers can help alert the DBA to unauthorized tampering with a production system, of course, but DDL triggers can't tell you everything. At some point, you will need to implement your own checks. Randy certainly reached that point!  Read more...

If you are a SQL Server DBA, you realize that the performance of cursors is not great and they should be avoided where possible. One place it is difficult to avoid cursors is individual row processing within a trigger. Amin Sobati brings us a new article that shows just how you can avoid this.   Read more...

If you are a SQL Server DBA, you realize that the performance of cursors is not great and they should be avoided where possible. One place it is difficult to avoid cursors is individual row processing within a trigger. Amin Sobati brings us a new article that shows just how you can avoid this.   Read more...

From SQL Server trainer and guru Andy Warren, he are a few short nuggets that you might not realize about triggers.  Read more...

If you are a SQL Server DBA, you realize that the performance of cursors is not great and they should be avoided where possible. One place it is difficult to avoid cursors is individual row processing within a trigger. Amin Sobati brings us a new article that shows just how you can avoid this.   Read more...

In this short demonstration, you'll learn how to use DDL database triggers to prevent changes to product and audit changes to comply with Sarbanes-Oxley and other change management requirements. Free registration required.   Read more...

Performance tuning is an ongoing battle in SQL Server, but having a little knowledge up front when designing an application can greatly reduce the efforts. Do you know which performs better: stored procedures or triggers? There aren't many places where the two are interchangeable, but knowing the impacts of each might change the way you build an application. Read about this analysis by Vijaya Kumar.   Read more...

Have you ever needed to audit your SQL Server 2000 database for changes to a table? A simple auditing solution is presented here by new author Tiago Silva using an INSTEAD OF trigger.   Read more...

This is the second of a two part series on how triggers work in the two latest versions of MS SQL Server. The first part dealt with what is common between the two versions. This article will detail what's been added to SQL Server 2000.   Read more...

This article by Jack Corbett explains what triggers are, the different types, and how to avoid common mistakes.  Read more...

If you have never used an instead of trigger, it's a great mechanism for evading table triggers in certain situations. MVP Andy Warren brings you part one of this SQL School video.  Read more...

Continuing with his series on using auditing information to roll transactions forward or back, David McKinney shows us how to generate audit triggers using XML.  Read more...