1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
CREATE TRIGGER [TR_audit_loginsa]
ON ALL SERVER
FOR LOGON
AS
BEGIN
DECLARE @DataTrigger XML
SET @DataTrigger = EVENTDATA() ;
IF ORIGINAL_LOGIN()= 'sa'
INSERT INTO master..audit_loginsa
SELECT @DataTrigger.value('(/EVENT_INSTANCE/LoginName)[1]', 'varchar(50)'),
@DataTrigger.value('(/EVENT_INSTANCE/LoginType)[1]', 'varchar(50)'),
@DataTrigger.value('(/EVENT_INSTANCE/PostTime)[1]', 'datetime'),
@DataTrigger.value('(/EVENT_INSTANCE/ClientHost)[1]', 'sysname')
END
GO
ENABLE TRIGGER [TR_audit_loginsa] ON ALL SERVER
GO |
