Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Share this Page URL
Help

Chapter 30. Creating and Managing Triggers > Using CLR Triggers - Pg. 988

988 CHAPTER 30 Creating and Managing Triggers --Name ---------------------- --tr_TableAudit --tr_ddl_IndexAudit create_date ----------------------- 2009-06-18 12:48:43.140 2009-06-22 06:35:10.233 modify_date ----------------------- 2009-06-18 12:48:43.140 2009-06-22 06:35:10.233 is_disabled ----------- 0 0 --SERVER SCOPED DDL TRIGGERS select left(name,20) `Name', create_date, modify_date, is_disabled from sys.server_triggers --Name create_date modify_date is_disabled ---------------------- ----------------------- ----------------------- ----------- --tr_LoginAudit 2009-06-18 12:13:46.077 2005-06-18 12:13:46.077 0 Using CLR Triggers CLR triggers are triggers based on the CLR. CLR integration, which was added with SQL Server 2008, allows for database objects (such as triggers) to be coded in one of the