Solved

display progress of executing query

Posted on 2006-11-28
2
312 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

752 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