2 SQL Tracefiles on startup

Question

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

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: 2727 More actions · Answer 2

Or this:

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

Lee

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

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'

alnor Right there with Babe Points: 761 More actions · Answer 4

Right there with Babe

Points: 761

April 5, 2016 at 5:10 pm

Thanks for the script

alnor Right there with Babe Points: 761 More actions · Answer 5

A second SQL restart stopped the trace file - not sure why it didnt stop the first time.