로그인 감사

특정 사용자에 대한 로그인 감사 기록 남기기

/****** Object:  Audit [ServerAuditSpecification-20201106-140647]    Script Date: 2020-11-06 오후 2:14:26 ******/
CREATE SERVER AUDIT [ServerAuditSpecification-20201106-140647]
TO APPLICATION_LOG
WITH
(	QUEUE_DELAY = 1000
	,ON_FAILURE = CONTINUE
	,AUDIT_GUID = '298f9952-679f-41d9-9fef-1be263f4ddf6'
)
WHERE ([server_principal_name]='도메인\계정' OR [server_principal_name]='도메인\계정')
ALTER SERVER AUDIT [ServerAuditSpecification-20201106-140647] WITH (STATE = ON)
GO