/****************************************************/
/* Created by: SQL Server 2019 CTP2.4 Profiler */
/* Date: 07/12/2019 02:36:40 PM */
/****************************************************/
-- Create a Queue
DECLARE @rc INT;
DECLARE @TraceID INT;
DECLARE @maxfilesize BIGINT;
SET @maxfilesize = 5;
-- Please replace the text InsertFileNameHere, with an appropriate
-- filename prefixed by a path, e.g., c:\MyFolder\MyTrace. The .trc extension
-- will be appended to the filename automatically. If you are writing from
-- remote server to local drive, please use UNC path and make sure server has
-- write access to your network share
EXEC @rc = sp_trace_create
@TraceID OUTPUT
, 2 --option of 2 = trace rollover
, N'c:\database\xe\LogonAttempts'
, @maxfilesize
, NULL
, 10 --number of rollover files = 10 (last parameter passed to proc)
;
--parameters are: traceid, options, filename, max file size, stop time, file count
IF (@rc != 0)
GOTO error;
-- Client side File and Table cannot be scripted
-- Set the events
DECLARE @on BIT;
SET @on = 1;
EXEC sp_trace_setevent @TraceID, 14, 1, @on;
EXEC sp_trace_setevent @TraceID, 14, 2, @on;
EXEC sp_trace_setevent @TraceID, 14, 3, @on;
EXEC sp_trace_setevent @TraceID, 14, 6, @on;
EXEC sp_trace_setevent @TraceID, 14, 7, @on;
EXEC sp_trace_setevent @TraceID, 14, 8, @on;
EXEC sp_trace_setevent @TraceID, 14, 9, @on;
EXEC sp_trace_setevent @TraceID, 14, 10, @on;
EXEC sp_trace_setevent @TraceID, 14, 11, @on;
EXEC sp_trace_setevent @TraceID, 14, 12, @on;
EXEC sp_trace_setevent @TraceID, 14, 14, @on;
EXEC sp_trace_setevent @TraceID, 14, 21, @on;
EXEC sp_trace_setevent @TraceID, 14, 23, @on;
EXEC sp_trace_setevent @TraceID, 14, 25, @on;
EXEC sp_trace_setevent @TraceID, 14, 26, @on;
EXEC sp_trace_setevent @TraceID, 14, 35, @on;
EXEC sp_trace_setevent @TraceID, 14, 41, @on;
EXEC sp_trace_setevent @TraceID, 14, 49, @on;
EXEC sp_trace_setevent @TraceID, 14, 51, @on;
EXEC sp_trace_setevent @TraceID, 14, 57, @on;
EXEC sp_trace_setevent @TraceID, 14, 60, @on;
EXEC sp_trace_setevent @TraceID, 14, 64, @on;
EXEC sp_trace_setevent @TraceID, 14, 66, @on;
EXEC sp_trace_setevent @TraceID, 20, 1, @on;
EXEC sp_trace_setevent @TraceID, 20, 3, @on;
EXEC sp_trace_setevent @TraceID, 20, 6, @on;
EXEC sp_trace_setevent @TraceID, 20, 7, @on;
EXEC sp_trace_setevent @TraceID, 20, 8, @on;
EXEC sp_trace_setevent @TraceID, 20, 9, @on;
EXEC sp_trace_setevent @TraceID, 20, 10, @on;
EXEC sp_trace_setevent @TraceID, 20, 11, @on;
EXEC sp_trace_setevent @TraceID, 20, 12, @on;
EXEC sp_trace_setevent @TraceID, 20, 14, @on;
EXEC sp_trace_setevent @TraceID, 20, 21, @on;
EXEC sp_trace_setevent @TraceID, 20, 23, @on;
EXEC sp_trace_setevent @TraceID, 20, 26, @on;
EXEC sp_trace_setevent @TraceID, 20, 30, @on;
EXEC sp_trace_setevent @TraceID, 20, 31, @on;
EXEC sp_trace_setevent @TraceID, 20, 35, @on;
EXEC sp_trace_setevent @TraceID, 20, 49, @on;
EXEC sp_trace_setevent @TraceID, 20, 51, @on;
EXEC sp_trace_setevent @TraceID, 20, 57, @on;
EXEC sp_trace_setevent @TraceID, 20, 60, @on;
EXEC sp_trace_setevent @TraceID, 20, 64, @on;
-- Set the Filters
DECLARE @intfilter INT;
DECLARE @bigintfilter BIGINT;
-- Set the trace status to start
EXEC sp_trace_setstatus @TraceID, 1;
-- display trace id for future references
SELECT
TraceID = @TraceID;
GOTO finish;
error:
SELECT
ErrorCode = @rc;
finish:
GO