Alternative to Sql Profiler - IdealSqlTracer Overview
http://idealprogrammer.com/net-langua... - Wade Harvey demonstrates how to use IdealSqlTracer to grab all of the SQL generated behind the scenes on a web page or a desktop app and format that sql into notepad. IdealSqlTracer is an open source free alternative to SQL Profiler. IdealSqlTracer uses sp_trace_create, sp_trace_filter, and sp_trace_setstatus procs to allow you to create customized traces that reduce a lot the noise that normally occurs when using SQL Profiler.