I've got a problem on an SQL Server 2005 Express instance, and I need to see exactly what is being run, since what I believe is being run works fine when I run it from Management Studio.
It appears that Profiler is not available for SQL Server 2005 Express. When I attempt to run SQL Server 2000 Profiler against the 2005 Express edition, I get the following message : "To Connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO)." However, in searching Express Management Studio for a menu to do something similar to what I need, I can't find anything. I found a third party profiler knock off for Express, but prefer to not to install a client app on my customer's server.
How do you find out what is being run in SQL Server 2005 Express?
I use this sql server profiler. Its free, its open-source.