1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
CREATE TRIGGER Login
ON ALL SERVER
FOR CREATE_LOGIN, DROP_LOGIN
AS
DECLARE @data XML
DECLARE @subject nvarchar(100)
DECLARE @body nvarchar(2000)
SET @data = EVENTDATA()
SET @subject = @data.value('(/EVENT_INSTANCE/EventType)[1]', 'nvarchar(100)')
SET @body = @data.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'nvarchar(2000)')
+ ' ON ' + @data.value('(/EVENT_INSTANCE/ServerName)[1]', 'nvarchar(2000)')
+ ' PAR ' + @data.value('(/EVENT_INSTANCE/LoginName)[1]', 'nvarchar(2000)')
+ ' A ' + @data.value('(/EVENT_INSTANCE/PostTime)[1]', 'nvarchar(2000)')
EXEC msdb.dbo.sp_send_dbmail @profile_name='Messagerie',
@recipients='Mon Mail',
@subject = @subject,
@body = @body; |
Partager