up vote 1 down vote favorite
share [g+] share [fb]

In SQL Server Management Studio Express 2005 is it possible to output the date and time that a query completed in the Results or Messages windows?

(without having to manually add a SELECT Getdate() to every query)

link|improve this question
100% accept rate
I looked through the options and there's nothing that looks like the IDE can do what you want it to do. – ta.speot.is May 10 '10 at 11:29
feedback

2 Answers

up vote 0 down vote

This is only part of what you are looking for, but if you turn on the Include Client Statistics option, you'll get a new Client Statistics tab when you run your query that will include the time the query was run. It's under Query>Include Client Statistics.

link|improve this answer
I'll try this when I'm back at work tomorrow AM – Shevek May 10 '10 at 17:35
which version of SQL Management Tools are you using? I can't find that option anywhere in 2005 and the Help does not shed any light. – Shevek May 11 '10 at 6:44
@Shevek - I'm using 2008, my apologies for not specifying that in my response. I'm glad that you were able to solve your problem. – Zachary May 11 '10 at 12:15
no problem, thanks anyway! – Shevek May 11 '10 at 12:43
feedback
up vote 0 down vote accepted

Upgraded to 2008 version which has a Properties panel which includes the Connection finish time - this is exactly what I need!

enter image description here

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.