Re: ADO.NET Timout

A SP can be called asynchronously from ADO.NET (2.0) by using the
BeginExecute method of the Command object. ADO classic supports async ops as
well. I'll be discussing this in my session on Async operations at VSLive
this week (Thursday 11:30) in Vegas.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Lit" <sql_agentman@xxxxxxxxxxx> wrote in message
news:exSXh3IlGHA.4872@xxxxxxxxxxxxxxxxxxxxxxx
Mary,

How can I call a stored procedure to do its thing asynchronously.

What is the best way of doing this?

Thank You,

Lit


"Mary Chipman [MSFT]" <mchip@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:mfs592l5gnd5lhm1pr28o9mt6q0d5bq1e0@xxxxxxxxxx
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: transaction with unknown nbr of commands
    ... into a temp table or table variable in the stored procedure code. ... the possibility that some rows would commit and others not. ... >> explicit transaction with a BEGIN TRAN statement, ... Does SQL Server 2000 have some capabilities that I should ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: transaction with unknown nbr of commands
    ... > then call your wrapper stored procedure, passing it all of the user ... > explicit transaction with a BEGIN TRAN statement, ... Does SQL Server 2000 have some capabilities that I should ... But this also sounds like multiple trips from the application to SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO.NET Timout
    ... How can I call a stored procedure to do its thing asynchronously. ... as a single unit of work, you can implement an explicit transaction. ... 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)
  • Re: How to get list of EventClasses in MSSQLServer2000
    ... statement inside a stored procedure has completed.') ... SQL Server statement or stored procedure.') ... Plan','Displays the plan tree of the Transact-SQL statement executed.') ... Login','Occurs when a SQL Server login is added or removed; ...
    (microsoft.public.sqlserver.security)
  • Re: Accessing FoxPro Free Table
    ... which the SQL Server service is running. ... account, ... > If you are creating a stored procedure and you want> to make sure that the procedure definition cannot be> viewed by other users, you can use the WITH ENCRYPTION> clause. ... The procedure definition is then stored in an> unreadable form. ...
    (microsoft.public.data.odbc)