34,590
社区成员
发帖
与我相关
我的任务
分享
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