Trigger Order III

Preventing Trigger Execution

Creating a DDL Trigger

DDL Trigger Execution

Generate Trigger DDL

Dynamically generate trigger DDL and write to individual SQL files.

Add user with DDL Trigger

DDL trigger will add a user to a newly created database and assign db_owner role. It can be modified for what role is required.

Extend SQL Server DDL Triggers for more functionality: Part 2

A previous tip, SQL Server DDL Triggers to Track All Database Changes, generated a lot of discussion involving ways to make the provided DDL trigger more useful. Check out this tip to expand your knowledge on DDL Triggers.

Extending SQL Server DDL Triggers for More Functionality

In this tip Aaron Bertrand describes some of the ways in which you can extend the DDL trigger functionality.

DDL trigger

Creating a recycle bin for SQL Server 2005\2008

Using a DDL trigger, two schemas and a stored procedure recycle bin functionality can be create in SQL Server.