Whats the output for this in DDL trigger?
declare @data xml
set @data = EVENTDATA()
SELECT @data.value('(/EVENT_INSTANCE/LoginName)[1]', 'varchar(256)')
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)