Server Trigger: ddl_trig_database Server Trigger: ddl_trig_database| 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 |
| Event Type | First | Last | Event Group Type |
|---|---|---|---|
| CREATE_DATABASE |
|
|
| 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)') |