tags:

views:

59

answers:

0
Q: 

SQL Server 2000 DTS transaction scope question

I have 2 SQL Task, each calling different stored procedures. The query in each SP is enclosed between BEGIN and END trans. I added "OnSuccess" of task 1 then move to task 2. I also added 'Fail Package On Error" and enabled "Tansactions" at package level.

Question - If task2 fails, shouldn't task 1 be rolled back?

related questions

Is there a "poor man's" alternative to RedGate for scripting out entire database schema?
My SQL Server 2000 Transaction Log Size Seems Small
Is there a way to script diagrams in SQL 2000 (or save them another way)?
Programatically renaming a table in SQL Server 2000 - is sp_rename the only solution?
I am getting a "fatal error 7987" error from SQL Server 2000
SQL Server 2000 and System.Transactions.TransactionScope()
Why should I upgrade from SQL2000 to SQL2005?
Can I protect against SQL Injection by escaping single-quote and surrounding user input with single-quotes?
Passing timestamp parameters in SQLAnalyzer to debug stored procedures
Linked Server Performance and options
SQL Server 2005: Importing data from SQL Server 2000
How do I perform a case-sensitive search and replace in SQL 2000/2005?
Warm Backup
Benefits of SQL Server 2005 over 2000
How can I create a human-readable script for every DTS package on a SQL server?
Deleting Rows from a SQL Table marked for Replication
In what situations would you get different users seeing different rows in a table on SQL Server?
Date object last modified
Improving SQL Server performance on VMware under Linux
The log file for database is full.
SQL Server 2000 - Debugging Deadlocks
Strategy for identifying unused tables in SQL Server 2000?
In SQL Server 2000, is there a sysobjects query that will retrieve user views and not system views?
Upgrading Sharepoint 3.0 to SQL 2005 Backend?
How do you deal with transport-level errors in SqlConnection?