Home Forums SQL Server 2005 T-SQL (SS2K5) Receiving duplicate key insert error with DISTINCT clause RE: Receiving duplicate key insert error with DISTINCT clause

  • March 11, 2009 at 2:24 pm

    #957882

    Hi Eric

    The NOLOCK may be your problem if there are very much data manipulation while your statement is running. Maybe have a look at:

    SET TRANSACTION ISOLATION LEVEL SNAPSHOT

    Greets

    Flo