2 SQL Tracefiles on startup

Question

Post reply

2 SQL Tracefiles on startup

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

DouglasH SSCommitted Points: 1669 More actions · Answer 1

DouglasH

SSCommitted

Points: 1669

March 23, 2016 at 8:08 pm

#1867293

OK, that looks like it has been successfully switched off.

Could you run this please

SELECT * from fn_trace_getinfo(0)

Lee Linares SSCrazy Points: 2707 More actions · Answer 2

Lee Linares

SSCrazy

Points: 2707

March 24, 2016 at 8:37 am

#1867457

Or this:

SELECT name, create_date FROM sys.procedures WHERE is_auto_executed = 1

Lee

Jon.Morisi SSChampion Points: 12846 More actions · Answer 3

Learn Who Started that Trace with the Default Trace

slight mod:



DECLARE @FileName VARCHAR(MAX)  

SELECT @FileName = SUBSTRING(path, 0, LEN(path)-CHARINDEX('\', REVERSE(path))+1) + '\Log.trc'

FROM sys.traces

WHERE is_default = 1;  

SELECT

    LoginName,

    HostName,

    ApplicationName,

    StartTime,

    TextData

FROM sys.fn_trace_gettable( @FileName, 5 ) AS gt

WHERE EventClass = 175

and TextData like 'exec sp_trace_setstatus %,1'