How are you calling sqlserver. If you do it via VBA, you can set a local
variable to the current time, call sqlserver, then check the variable for
time passed.

--
-oj


[quoted text, click to view]

I use Access ADP, so I do not have SQL analyzer to tell me how long takes to
execute my query.
Is it possible to have my query to tell me how long take to run my query?

Any information is great appreciated,

Souris,

You can try:

SET STATISTICS TIME ON

.... but I'm not sure how you can go about collecting the statistics from
Access. Another option, perhaps, would be to do everything in Access using
local variables to calculate the difference in time between when you submit
the query and when it's returned...


--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--


[quoted text, click to view]