Advertisement

03.28.2008 at 04:15PM PDT, ID: 23278781
[x]
Attachment Details

Track execution of query in a batch

Asked by MistyAyn in MS SQL Server

Tags: Microsoft, SQL Server, 2000

If a query in a batch fails, shouldn't the whole batch fails? Here is my scenario I've got hundred of stored procedures running in a batch so

Begin
Execute stored procedure
Execute stored procedure
Execute stored procedure
.
.
.
End

Using SQL Profiler I'm viewing all events of class SQL:Batch Complete. At the same time I'm logging Events SP:Starting.  When I notice an issue with my data I look at both logs.  I can see the stored procedure that would update my data in the Batch Complete but it never shows up in SP:Starting.

Until today we thought maybe we weren't sending the data to the database but now we know we are but the query does not actually get executed, if anyone can help me I would greatly appreciate it.  
If Start Free Trial
 
Keywords: Track execution of query in a batch
Title
1 Batch File
2 Batch Find and Replace for Word.
3 Batch Download
4 Is it posible to prove a file was copied …
5 Batch PDF Generation
6 batch file to execute on login
 
Loading Advertisement...
 
[+][-]03.28.2008 at 04:33PM PDT, ID: 21234783

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.28.2008 at 04:36PM PDT, ID: 21234790

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.29.2008 at 12:05PM PDT, ID: 21237726

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: Microsoft, SQL Server, 2000
Sign Up Now!
Solution Provided By: momi_sabag
Participating Experts: 2
Solution Grade: A
 
 
[+][-]06.23.2008 at 06:23AM PDT, ID: 21845912

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]06.27.2008 at 06:55PM PDT, ID: 21888819

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628