August 23, 2002 at 6:28 am
I ran a script over night and I closed it this morning without looking to see how long it took to run. Is there anyway I can find out? Is there a log on the server that I can look at?
August 23, 2002 at 7:10 am
To the best of my knowledge the start time is the only thing you can get, not the run time total.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
August 23, 2002 at 10:25 am
Unless you had profiler running, there isn't. QA shows the time in the lower right corner. You can also use select getdate()s bracketed around your queries and output this to a file (isql or osql)
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply