Logging ALL Queries on a SQL Server 2008 Express Database?

Question

Is there a way to tell SQL Server 2008 Express to log every query (including each and every SELECT Query!) into a file?

It's a Development machine, so the negative side effects of logging Select-Queries are not an issue.

Before someone suggests using the SQL Profiler: This is not available in Express (does anyone know if it's available in the Web Edition?) and i'm looking for a way to log queries even when I am away.

Answer 1

SQL Server Profiler:

• File → New Trace
• The "General" Tab is displayed.
• Here you can choose "Save to file:" so its logged to a file.
• View the "Event Selection" Tab
• Select the items you want to log.
• TSQL → SQL:BatchStarting will get you sql selects
• Stored Procedures → RPC:Completed will get you Stored Procedures.

More information from Microsoft: SQL Server 2008 Books Online - Using SQL Server Profiler

Update - SQL Express Edition:

A comment was made that MS SQL Server Profiler is not available for the express edition.
There does appear to be a free alternative: Profiler for Microsoft SQL Server 2005 Express Edition