Solved

display progress of executing query

Posted on 2006-11-28
2
307 Views
Last Modified: 2008-02-01
I am using SSMS to execute a batch, which has multiple long running updates statements. SSMS only displays the results of the updates statements (how many rows were affected) after all the queries in the batch have completed. Is there any way to get SSMS to display the result of each query as soon as it completes?  So that i can get some feedback of it's progress while it is executing rather than waiting for it to be done?

thx,

0
Comment
Question by:brokeMyLegBiking
2 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 18034132
The only way you can get any feedback would be separating each query with a GO and add print statements such as:
PRINT 'Query XYZ completed'

But you should understand that adding GO statement could make your queries syntactically incorrect.
0
 
LVL 4

Author Comment

by:brokeMyLegBiking
ID: 18036917
k, thx, I guess that's what I expected.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now