views:

950

answers:

4

is there a sql server profiler for MSsql expess ? maybe an open source one ? or maybe just a tool that helps me see what query is passed to the database ?

+5  A: 

There's a free one available at: http://code.google.com/p/sqlexpressprofiler

Jose Basilio
yh but there is no documentation :s
Yassir
+1  A: 

Try http://sqlprofiler.googlepages.com/

Gary.Ray
+1  A: 

Yes there is: http://sqlprofiler.googlepages.com/

Rodrigo Guerreiro
+1  A: 

IIRC, the profiler is one of the features not available for SQL Server Express.

However, I'm also under the impression that SQL Server Express still supports many of the features of the for-pay editions, and it's just that they are disabled in the Express Edition of Management Studio. So if you also have access to a full db and the management studio that comes with you might be able to point that profiler at your express installation.

In this case I suspect that won't work, since the profiler also depends on an extra provided by the database. Still, it's worth a shot.

If it doesn't work there are some third party tools available that should be able to do what you want.

Joel Coehoorn
does +1 mean this is true?
Simon_Weaver