Re: ADO.NET Timout

If the connection is terminated, then any active transactions that are
occuring inside the stored procedure that have not yet been committed
will be rolled back. Any committed transactions will be preserved. If
you want all work items inside of the stored procedure to be handled
as a single unit of work, you can implement an explicit transaction.
For more information, see "Explicit Transactions" in SQL Server Books
Online.

--Mary

On Wed, 14 Jun 2006 11:53:31 -0700, "Lit" <sql_agentman@xxxxxxxxxxx>
wrote:

Hello,

The default ADO.NET Timeout is 30 seconds.
If I execute a Stored procedure that takes lets say 120 seconds then what
happens.

ADO.NET Times and throws an exception

But what about SQL Server Does SQL Server keep on Executing the Stored
procedure?

Thanks

Lit

.

Relevant Pages

  • Re: Re using Stored Procedures
    ... optimized plan of execution to run the stored procedure. ... cached by SQL Server and may be reused on a subsequent calls. ... >I have a system which processes 1000's of transactions per hour. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Database record disappear
    ... happening at SQL Server level when you execute the insertion related ... In stored procedure you can execute select statment after insert that ... some transactions are blocked by some other transactions. ...
    (microsoft.public.sqlserver)
  • Re: ADO.NET Timout
    ... occuring inside the stored procedure that have not yet been committed ... Any committed transactions will be preserved. ... If I execute a Stored procedure that takes lets say 120 seconds then what ... But what about SQL Server Does SQL Server keep on Executing the Stored ...
    (microsoft.public.dotnet.framework.adonet)
  • Running a SQL query vs stored procedure
    ... SELECT * FROM Transactions WHERE Ticket=@Ticket ... IF EXISTS (SELECT TimeStamp FROM Transactions WHERE Ticket=@Ticket) ... If I run this as a stored procedure it is usually, but not always, ... I can run this exact query in query analyzer and it takes ...
    (microsoft.public.sqlserver)
  • Re: Update Question
    ... You have a couple of choices on transactions. ... Control from ADO.NET ... Control from SQL Server through a stored procedure ... procedure and allow SQL Server to handle the transaction. ...
    (microsoft.public.dotnet.framework.adonet)
Loading