What is command to identify existing Traces

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

Express12 SSCoach Points: 18514 More actions · Answer 1

SSCoach

Points: 18514

September 24, 2007 at 7:49 am

SELECT * FROM fn_trace_getinfo(0)

BT

Express12 SSCoach Points: 18514 More actions · Answer 2

SSCoach

Points: 18514

September 24, 2007 at 11:00 am

Another cmd:

select * from sys.traces

BT

EugeneZ-162636 Default port Points: 1448 More actions · Answer 3

Default port

Points: 1448

September 24, 2007 at 11:10 am

try

DBCC TRACESTATUS

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 4

you can also do an sp_who2 and the app name will say SQL Profiler