USE [master] GO CREATE SERVER AUDIT [Audit Broker Login] TO FILE ( FILEPATH = N'' ,MAXSIZE = 0 MB ,MAX_ROLLOVER_FILES = 2147483647 ,RESERVE_DISK_SPACE = OFF ) WITH ( QUEUE_DELAY = 1000 ,ON_FAILURE = CONTINUE ,AUDIT_GUID = '95e06335-fe0e-4bfd-9040-a77bfb9fbde8' ) ALTER SERVER AUDIT [Audit Broker Login] WITH (STATE = OFF) GO CREATE SERVER AUDIT SPECIFICATION [Audit Broker Login Specs] FOR SERVER AUDIT [Audit Broker Login] ADD (BROKER_LOGIN_GROUP) WITH (STATE = OFF) GO