http://blogs.technet.com/b/vipulshah/archive/2007/04/16/default-trace-in-sql-server-2005.aspxThe Default Trace is something completely new that Microsoft has implemented to audit certain events in the system, which you can report on via Management Reports. To verify if the default trace is running, run following query: select * from sysen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/vipulshah/archive/2007/04/16/default-trace-in-sql-server-2005.aspx#3350446Tue, 17 Aug 2010 10:01:38 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3350446sri<p>am currently working in sql 2008 profiler. in 2005 i can see Audit broker login event but where as not present in the 2008. why is not there? i can see some of the event which are there in 2005 but not in 2008</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3350446" width="1" height="1">http://blogs.technet.com/b/vipulshah/archive/2007/04/16/default-trace-in-sql-server-2005.aspx#3185324Sun, 18 Jan 2009 19:44:47 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3185324log_nnn.trc, who runs this profiler | keyongtech<p>PingBack from <a rel="nofollow" target="_new" href="http://www.keyongtech.com/2242905-log_nnn-trc-who-runs-this">http://www.keyongtech.com/2242905-log_nnn-trc-who-runs-this</a></p> <img src="http://blogs.technet.com/aggbug.aspx?PostID=3185324" width="1" height="1">