PHISSUG

I would like to know if there are logging feature for SQL 2000 where I can see who uses/attempts to connect to the database using SQL Analyzer?

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.

Any guide that I may use to perform the stated scenario?

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.

Sir, though this might be irrelevant, you may want to know that SQL SErver 2008 have this kind of feature that you want. There is a new feature called SQL Server Audit that you might want to check. :)

or is there a trigger that I can create that logs Query Analyzer usage event?

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.