SQL Server 2005 Express: Where is the Profiler?

i'm reading on Microsoft's site that SQL Server 2005 Express Edition has Profiler:

alt text

Profiler
Express
Local and Relational Servers only.

(i'm not sure what a non-relational SQL Server is, but whatever)

It says it's there, where is it?


In SQL Server 7, SQL Server 2000, SQL Server 2005 and SQL Server 2008, i would go to the Tools menu:

alt text

But in SQL Server 2005 Express Edition, Microsoft decided to hide it:

alt text


Solution 1:

Express only gives you the option of running server side traces for profiling, but I don't think it gives you free access to the SSMS tool?

Nonetheless, there is a perfectly good open source version of the profiler tool that should work with your express edition.

http://sites.google.com/site/sqlprofiler/

Solution 2:

Remember that you're dealing with SQL Server Management Studio Express, which does not assume you have a copy of the rest of the SQL Server client tools installed.

Since this is SQL Server 2005, do a search for Profiler90.exe. That's the executable for Profiler. It is normally installed under C:\Program Files\Microsoft SQL Server\90\Tools\Binn.