yung sql profiler, me option yun n save to file.
pero syempre kelangan mo iwan n nakabukas yung profiler mo ska lagyan mo ng filter para query analyzer lang yun ma-log.
hi mpMS, please check this site.
http://www.sqlservercentral.com/articles/Administering/auditingwithsqlprofiler/1461/
How about SQL Server Enterprise Manager > Management > Current Activity > Process Info.
am not sure if that can be done. the only solution in 2005 is the profiler. you can filter the traces to just track query analyzer.