The Best Damn Exchange, SQL and IIS Book Period

Chapter 25

DDL Triggers

Solutions in this chapter:

■ DDL Triggers Explained

■ Implementing DDL Triggers

■ Managing DDL Triggers

■ Scenarios for Deploying DDL Triggers

☑ Summary

☑ Solutions Fast Track

☑ Frequently Asked Questions

Introduction

This chapter introduces DDL triggers. It explains what they are, demonstrates how to implement them, and shows you when to implement them. It also provides real-world examples of how and when DDL triggers can be used to help secure an SQL Server.

DDL Triggers Explained

Data Definition Language (DDL) is the subset of T-SQL instructions and statements that define structure, whether that structure is objects like tables and views, schemas, or security principals like server logins and database users. Although triggers have ...