Solved

SQL SERVER 2000/2005

Posted on 2009-04-08
9
194 Views
Last Modified: 2012-05-06
I am using query analyzer to run the script .script is so longer.I want to verify or check which stage  has been completed during the script is running like when we take a backup its shows percentage 10,20 and so on .....on the
message window in the query anaylzer

Can I add this information in my script

Thanks
0
Comment
Question by:furqan_trakker
[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
  • 4
  • 2
  • 2
  • +1
9 Comments
 
LVL 5

Expert Comment

by:mfhorizon
ID: 24094657
Hi furqan_trakker,

If your script is so longer and you want confirmation of execution in between, assuming that code is 1000 lines, i would select first 100 lines of code with taking care 100th line is with complete syntax and will EXECUTE the script, it will confirm me in the Message Pane below. I will comment these lines and will select next 100 lines with complete syntax and will repeat it until my script is completed.

Other way is you can program a vb form which executes every command and shows you result in a text box....

Hope you will find it well.

Cheers!!
0
 
LVL 12

Accepted Solution

by:
udaya kumar laligondla earned 500 total points
ID: 24094673
add statements for each stage as
Print "stage A1"
this will print when ever a stage is reached
0
 

Author Comment

by:furqan_trakker
ID: 24094709
Hello mfhorizon
have you taken a backup of a database on query analyzer ?
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
LVL 2

Expert Comment

by:TejasShahMscIT
ID: 24094769
Hi,

You can write "select 'Upto here' OR PRINT 'Upto here' " to make sure upto which line code has run.

0
 

Author Comment

by:furqan_trakker
ID: 24094850
I have added print statement after some lines of code but messages print all at the same time just
code split into 6 stages

print 'Stage 1 Completed'
print 'Stage 2 Completed' and so on

but its print all after script completed
0
 
LVL 12

Expert Comment

by:udaya kumar laligondla
ID: 24094919
use GO after the print statement
if you have configured some thing else as batch seperated use the same.
0
 
LVL 5

Expert Comment

by:mfhorizon
ID: 24094967
Yes, you must use GO to tell the interpretor to execute next queries...
0
 
LVL 5

Expert Comment

by:mfhorizon
ID: 24094975
Bakckup on query analyzer is simply like this

BACKUP DATABASE [MCI] TO  DISK = N'local_path\backupname.bak' WITH NOFORMAT, NOINIT,  NAME = N'MCI-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO
0
 
LVL 5

Expert Comment

by:mfhorizon
ID: 24095041
TRY TO CHECK YOU EXISTING SCRIPT SHOULD NOT HAVE "SET ECHO OFF" OR ANY OTHER SQL COMMAND THAT PUTS THE OUTPUT MESSAGE OFF. If you find comment it and the try!!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

635 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