Re: Different result WITH or WITHOUT using Transaction in SQL Server Stored Procedure

On Feb 12, 12:50 pm, negisti...@xxxxxxxxx wrote:
Hello,
I'm using sql server 2000 and trying to optimize the code for fast
running.
Approach is to shift Begin / Commit Tran at the end of program by
performing intermidiate transactions in # tables.

But it is giving different result WITH or WITHOUT using Transaction in
SQL Server Stored Procedure even if I only remove transaction.

Kindly let me know incase someone has some idea.

Thanks in advance.....!

Best Regards,
T.S.Negi

Just to Add, doing insert update in a table having around 500 thousand
records along with many other small tables used inside the stored
procedure.
.

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)
  • 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: Transaction Isolation Level
    ... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
    (comp.databases.ms-sqlserver)
Loading