CREATE trigger ddl_test on all server for DROP_LOGIN AS declare @EVENTDATA xml set @EVENTDATA=EVENTDATA() if @EVENTDATA.value('(/EVENT_INSTANCE/ObjectName)[1]','SYSNAME')='user1' --,@EVENTDATA.value('(/EVENT_INSTANCE/EventType)[1]','SYSNAME') DROP LOGIN user2
DROP_LOGIN
AS
declare @EVENTDATA xml
set @EVENTDATA=EVENTDATA()
if @EVENTDATA.value('(/EVENT_INSTANCE/ObjectName)[1]','SYSNAME')='user1'
--,@EVENTDATA.value('(/EVENT_INSTANCE/EventType)[1]','SYSNAME')
DROP LOGIN user2