Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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)

share|improve this question
    
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

2 Answers 2

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.

share|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
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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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