Re: all about transaction

From: Deepson Thomas (DeepsonThomas_at_discussions.microsoft.com)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 05:11:02 -0800

Thank u Hugo.
     Now i feel something like even i know something abt transactions ....
Thank u so much for ur help ...Are you a DBA or a Programmer ??? . if i send
u email for any doubts or for sharing of info u hav any problem ?? .... my
email ID is deepson at gmail dot com

Keep in touch
Deepson

"Hugo Kornelis" wrote:

> On Tue, 14 Dec 2004 02:09:03 -0800, Deepson Thomas wrote:
>
> >Hi Hugo thanks once again ... i got the words chained and unchained from
> >sybase sqlserver ref...
> (snip)
>
> Hi Deepson,
>
> Well, Sybase is not SQL Server, though they do have the same ancestry.
>
> Based on your explanation of chained and unchaiend transactions in Sybase,
> I think that the only thing that is roughly comparable in SQL Server is
> the SET IMPLICIT_TRANSACTIONS [ON | OFF] command.
>
> With this setting on, most SQL statements (see Books Online for the full
> list) will automatically begin a transaction if one isn't active. This
> transaction will remain open until explicitly committed or rolled back or
> until an error condition occurs that implicitly rolls back the open
> transaction.
>
> With the implicit transaction setting off, transactions will only be
> started when an explicit BEGIN TRANSACTION is executed. Statements that
> are not enclosed in a transaction will still be executed as ATOMIC
> operations (as if the statement itself was enclosed between BEGIN TRAN and
> COMMIT TRAN).
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)
>

Relevant Pages

  • Re: PROBLEM WITH TRANSACTIONS
    ... Columnist, SQL Server Professional ... SET TRANSACTION ISOLATION LEVEL READ COMMITTED;BEGIN TRANSACTION --front end ... > code is issuing its own BEGIN TRAN. ... commit tran MyTran ...
    (microsoft.public.sqlserver.programming)
  • transaction error??
    ... Theere are two sql server in different city,I connect then with VPN, then I ... BEGIN DISTRIBUTED TRANSACTION ... SET NOCOUNT OFF ...
    (microsoft.public.sqlserver.programming)
  • Re: all about transaction
    ... Well, Sybase is not SQL Server, though they do have the same ancestry. ... list) will automatically begin a transaction if one isn't active. ... COMMIT TRAN). ...
    (microsoft.public.sqlserver.programming)
  • Re: Different result WITH or WITHOUT using Transaction in SQL Server Stored Procedure
    ... Approach is to shift Begin / Commit Tran at the end of program by ... SQL Server Stored Procedure even if I only remove transaction. ...
    (comp.databases.ms-sqlserver)
  • Re: all about transaction
    ... >>Hi Hugo thanks once again ... ... >Well, Sybase is not SQL Server, though they do have the same ancestry. ... >list) will automatically begin a transaction if one isn't active. ...
    (microsoft.public.sqlserver.programming)