Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I'm using Sql Server Management Studio 2012, and I'm wondering if there is a way to have a query show me at what time it was run and/or completed at. Basically just some kind of timestamp so that I know if I actually ran the query recently or not.
Thanks
Hitting F4 also enables properties view, which shows the start time, finish time, and run time.
Also, if you Include Client Statistics (under Query menu), you can get a history of when you ran the query, along with various statistics such as run time and number of rows.
Update, 2019-10-14: SSMS 18 now includes the completion time in the Messages pane of the results tab.
You can do something like below :
declare @timer datetime
select @timer = getdate()
select @timer as QueryStartTime
--- here goes actual query
select * from sysdatabases
--- end of query
select getdate() as QueryEndTime
select datediff(ms, @timer, getdate()) as TimeInMS
Even though SSMS will show you how much time it took to execute the query, I have included the datediff.
A possible solution could be to run your query in a stored procedure (which usually has the added benefit of speeding up subsequent runs of your query, since the execution plan will be stored) and at the end of your SP, write something into a log table you created for that purpose. (Classic candidates could be name of the SP and getdate(), or even a result summary, if applicable)