SQL Server profiler simplest settings

Got this off the LINQ videos on ASP site. (BTW cool stuff LINQ!)

• start the sql profiler
• click new trace
• connect to your database
• click on event selection and uncheck all
• still in event selection check show all events and also check show all columns
• Now check SP:StmtCompleted in events.
• Next check the TextData column for this event.
• Click Run

Enjoy!