[AccessD] Is it possible to see what SQL Server is doing (from Access)?

Brad Marks BradM at blackforestltd.com
Fri Aug 20 15:30:15 CDT 2010


I am fairly new to the world of using Access to get at SQL Server data.

Is there an easy way to see how SQL Server is processing an SQL
statement that is being sent to it from Access (Pass Through Query). 

We have several queries that run in less than 1 second but one similar
query takes 30 seconds. We would like to be able to see what SQL Server
is doing with hopes that we might be able to make this query run faster.


Thanks,
Brad

 




More information about the AccessD mailing list