Re: ADO.NET Timout

Bill,

Asynchronously operations, is your session about gambling?

:-)

Cor

"William (Bill) Vaughn" <billvaRemoveThis@xxxxxxxxxx> schreef in bericht
news:O7kzv$IlGHA.4024@xxxxxxxxxxxxxxxxxxxxxxx
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: Performance problem on initial call of stored procedure
    ... The initial call to a stored procedure that performs 3 sql select ... If you let the session set for around 5 minutes, ... The websphere configuration is running on a Windows NT machine and, ...
    (comp.sys.ibm.as400.misc)
  • Re: Performance problem on initial call of stored procedure
    ... The initial call to a stored procedure that performs 3 sql select ... If you let the session set for around 5 minutes, ... The websphere configuration is running on a Windows NT machine and, ...
    (comp.sys.ibm.as400.misc)
  • RE: Perms on Tempdb?
    ... be saved from one session of SQL Server to another. ... A local temporary table created in a stored procedure is dropped ... created the table ends and all other tasks have stopped referencing them. ...
    (microsoft.public.sqlserver.security)
  • Re: Perms on Tempdb?
    ... > be saved from one session of SQL Server to another. ... > automatically when the stored procedure completes. ... > created the table ends and all other tasks have stopped referencing them. ... > of a single Transact-SQL statement. ...
    (microsoft.public.sqlserver.security)
  • Re: Session variable vs. Stored Proc
    ... information from page one in hidden form fields, ... probably still better to store in session & run one stored proc ... > procedure OR would it be better to run a stored procedure the first page ...
    (microsoft.public.dotnet.framework.aspnet)
Loading