Profiler for Microsoft SQL Server 2005/2008 Express Edition

Aravind Kumar    SQL Server     Query Trace, SQL Server, SQl Server Express

Download “AnjLab Sql Profiler”

http://code.google.com/p/sqlexpressprofiler/downloads/list and install it.

Use the following SQL statement to know your database ID

SELECT dbid FROM master.dbo.sysdatabases WHERE name = ‘Yourdatabasename’

New trace and use filters to trace particular database.