SQL Server Query Logging

[evgeniosc]

I am using MS Access as a front-end to a SQL Server Database.

I execute various queries based on criteria on access forms.

What I would like, is to find a way in sql server to see the actual query sent to the server through a log or something.

PS: I used the showplan option in Jet Database that shows the query execution plan. The problem was that for server queries the only thing shown is "Remote SQL"

 

[TomKane]

You could try looking at the profiler - there is all sorts of information that you can get of of that