Wednesday, March 7, 2012

ddl trigger question

I made a ddl trigger on database for event group which is

ddl_table_events.

The question is: can I know inside the trigger logic

(after "as" keyword)
which event type of this event group has fired the

trigger?

my code:

use AdventureWorks
go
create trigger

TableEvents
on database
for ddl_table_events
as
select * from

sys.trigger_events
go

I found nothing in sys.trigger_events has

changed inside the trigger.

So finally, I want to know which of "create

table" , "alter table" or "drop
table" has fired the trigger?

Please take a look at the EVENTDATA function. This returns the event that was fired, the command that raised the event and so on. See below topic for more details:

http://msdn2.microsoft.com/en-us/library/ms173781.aspx

No comments:

Post a Comment