Home Forums SQL Server 2005 SQL Server 2005 General Discussion SQL transaction and lock of the table for SELECT RE: SQL transaction and lock of the table for SELECT

  • November 28, 2012 at 4:39 am

    #1563027

    Using uncommitted/nolock may well 'fix' the problem but please understand that you will be reading dirty data.

    If the transaction is to be rolled back then what does that be for the process that has read the dirty data ?


    Clear Sky SQL
    My Blog[/url]