# Server Trigger: ddl_trig_database

## Properties

Property | Value
--- | ---
Trigger Name | ddl_trig_database
Trigger ID | 1211151360
Trigger Type | SQL trigger
Enabled |
Microsoft Shipped |
Uses ANSI NULL |
Uses QUOTED IDENTIFIER |
Modify Time | 9/19/2010 3:28:03 AM
Create Time | 9/19/2010 3:28:03 AM

## Trigger Events

Event Type | First | Last | Event Group Type
--- | --- | --- | ---
CREATE_DATABASE |  |  |

## SQL

Script
CREATE TRIGGER ddl_trig_database ON ALL SERVER FOR CREATE_DATABASE AS PRINT 'Database Created.' SELECT EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','nvarchar(max)')

#### See also

List of Server Triggers