Using Transaction scope

Hi,

VB 2005 Prof, SQL server 2005, Windows application

- I am using transaction scope and within this scope I am passing multiple
SQL statements to the command.text

On executing, all is well.

But noticed that in case there is SQL server time out, then the transaction
doesn't fail.
Say, if the system had processed 2 sql statements from the bunch of multiple
statements in the command, then the database gets updated with these 2 sql
statements.

Ofcourse, if the transaction scope does fail , then there is no update

So why should the transaction be not enforced in case of an SQL server time
out? If this is a normal behaviour, then how to avoid this pitfall?

thanks.



.

Relevant Pages

  • Re: Transform Data Task, parameterized SP: "No value given for one or more required parameters&
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... >> SET NOCOUNT ON ... >> Global Variables and SQL statements in DTS ...
    (microsoft.public.sqlserver.dts)
  • Re: DataGrid - clever way to update DataSet
    ... If you are using SQL Server, then you could use CommandBuilder class that ... will allow you automatically build INSERT, UPDATE and DELETE SQL statements ... for your DataAdapter based on your SELECT statement. ...
    (microsoft.public.dotnet.framework.adonet)
  • Using Transaction Scope
    ... I am using transaction scope and within this scope I am passing multiple ... But noticed that in case there is SQL server time out, ... if the system had processed 2 sql statements from the bunch of multiple ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Another SQL Server Question
    ... SQL Server is a server and does not know anything about your ... It just accepts sql statements and will ... through the tables and rename them all by removing the "dbo" prefix. ...
    (comp.databases.ms-access)
  • Re: multiple sql statements
    ... I used SQL Server Enterprise Manager to get the starting point for the these ... SQL statements (since I want compatibility with SQL Server; ... > Maybe you can be more specific about how the command fails? ... What are the gory details of the exception? ...
    (microsoft.public.data.oledb)
Loading