Are you talking about sql2005 default traces? if so, yes, they will be in different directories like: C:SQLDATAMSSQL.1MSSQLLOG C:SQLDATAMSSQL.2MSSQLLOG
What Mike referred is best one to go to see the basic processing information, if you need further dig out on a specific set of queries then PROFILER or server side trace using SPs will help you a lot. But be clear on what you want.
Thank U guys, for the reply, I was asking like is there any command in QA which give us the present trace enabled not the default one but user defined - user defined in the sense set by the person who is interacting with QA , I hope I am clear enough Thanku.
SELECT * FROM fn_trace_getinfo(0) to view the data in that trace file, formore information on what users are running SP_WHO2 will get you more.
