Home Forums SQL Server 2008 SQL Server 2008 - General TRANSACTION and @@IDENDITY RE: TRANSACTION and @@IDENDITY

  • October 16, 2012 at 8:02 am

    #1549581

    GilaMonster (10/16/2012)

    C# Gnu (10/16/2012)

    Addition: so this in effect was my worry - that systems would be locked out while the transaction is open

    If they try to read rows that are locked, they have to wait until the locks are released.

    Chapter 6: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    Hmm, Seems like an option is missing to me!

    BEGIN TRANSACTION NOBLOCK

    I would have thought the default 'ISOLATION LEVEL COMMITED' select statement should return all committed rows and ignore any uncommitted rows - rather than wait forever.

    C# Gnu
    ____________________________________________________


    Excel Database Tasks : efficient business data processing
    Version 3.3 released February 2015