SQL Server 2005 Express: Where is the Profiler?
i'm reading on Microsoft's site that SQL Server 2005 Express Edition has Profiler:
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:
But in SQL Server 2005 Express Edition, Microsoft decided to hide it:
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.