Hi,

Below is the example code for DDL server level Trigger

declare @data xml,

@CommandText varchar(max)

set @data = eventdata()

set @CommandText=@data.value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','varchar(max)')

OUTPUT :-

FOR EVENTTYPE =DROP_LOGIN I am getting commandtext - DROP LOGIN [testing]

where as for CREATE_LOGIN and Alter_Login I am gettting Null

Could anyone of you assist me.

Thanks.