transactions and stored procedures

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: toylet (toylet_at_mail.hongkong.com)
Date: 03/19/04 

Date: Fri, 19 Mar 2004 20:37:22 +0800

can I do this while the connetion is alive?

begin transaction
execute sp_update_table_001
execute sp_update_table_002
commit/rollback

If the connection dies before the commit, will SQL server rollback the
transaction automatically? 

-- 
   .~.    Might, Courage, Vision. In Linux We Trust.
  / v \   http://www.linux-sxs.org
/( _ )\  Linux 2.4.22-xfs
   ^ ^    8:34pm up 2 days 13 min load average: 1.33 1.07 1.02

Relevant Pages

  • Re: Concurrent Connections / Shared Transaction
    ... In MARS there are fixed interleave points in the server. ... Do you mean that one will execute and ... bound sessions allow you to share the transaction space among ...
    (microsoft.public.dotnet.framework.adonet)
  • Urgent problem: Any help greatly appreciated
    ... I am trying to execute a number of SQL stored procedures in a single ... I really need to be able to execute these procedures in a single transaction ... SqlTransaction trans; ...
    (microsoft.public.dotnet.languages.csharp)
  • Urgent problem: Any help greatly appreciated
    ... I am trying to execute a number of SQL stored procedures in a single ... I really need to be able to execute these procedures in a single transaction ... SqlTransaction trans; ...
    (microsoft.public.dotnet.framework.adonet)
  • Urgent problem: Any help greatly appreciated
    ... I am trying to execute a number of SQL stored procedures in a single ... I really need to be able to execute these procedures in a single transaction ... SqlTransaction trans; ...
    (microsoft.public.dotnet.general)
  • Re: Concurrent Connections / Shared Transaction
    ... Do you mean that one will execute and ... bound sessions allow you to share the transaction space among ... > connections but doesn't give you concurrent access to it. ... > Server 2005 you can mix MARS plus asynchronous command execution to submit ...
    (microsoft.public.dotnet.framework.adonet)