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.

DDL Triggers Implementation

How to use DDL triggers and Query the Data with minimum performance impact.

Using DDL Trigger

Using DDL Triggers