Execution time

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

Execution time

Postby MariaJGrossi » Wed Apr 18, 2012 6:54 pm

Is there a way to see the execution time for each script or even for all scripts that have been run?
Thanks!
MariaJGrossi
 
Posts: 1
Joined: Wed Apr 18, 2012 6:49 pm

Postby eddie davis » Fri Apr 20, 2012 4:55 pm

Thank you for your forum post.

This is not available through the SQL Multi-script product.

However you maybe able to obtain the information you are looking for through SQL iteslf by enabling or turning on the SET STATISTICS TIME. This LINK to a msdn article may answer your question.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests