trace-date-function-usage-fro-amazon-rds-compliancy.sql

--
-- Trace date function usage (batch completed) for Amazon RDS compliancy
--

-- Create a Queue
declare @rc int
declare @TraceID int
declare @maxfilesize bigint
declare @DateTime datetime

set @DateTime = '2014-11-08 00:00:00.000'
set @maxfilesize = 10240

exec @rc = sp_trace_create @TraceID output, 0, N'C:\Trace\amazon-rds-date-function-usage', @maxfilesize, @Datetime
if (@rc != 0) goto error

-- Set the events
declare @on bit
set @on = 1
exec sp_trace_setevent @TraceID, 13, 1, @on
exec sp_trace_setevent @TraceID, 13, 9, @on
exec sp_trace_setevent @TraceID, 13, 11, @on
exec sp_trace_setevent @TraceID, 13, 6, @on
exec sp_trace_setevent @TraceID, 13, 10, @on
exec sp_trace_setevent @TraceID, 13, 12, @on
exec sp_trace_setevent @TraceID, 13, 14, @on
exec sp_trace_setevent @TraceID, 13, 26, @on
exec sp_trace_setevent @TraceID, 13, 35, @on


-- Set the Filters
declare @intfilter int
declare @bigintfilter bigint

exec sp_trace_setfilter @TraceID, 1, 0, 6, N'%getdate%'
exec sp_trace_setfilter @TraceID, 1, 1, 6, N'%sysdatetime%'
exec sp_trace_setfilter @TraceID, 1, 1, 6, N'%current_timestamp%'
exec sp_trace_setfilter @TraceID, 1, 0, 1, NULL
-- 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: