Home Forums SQL Server 2005 T-SQL (SS2K5) Reg: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED RE: Reg: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

  • Hi Gail, thanks for the reply, just want to confirm the following:

    I assume I should rather use these -

    Snapshot isolation.

    Read committed snapshot isolation.

    Database Snapshot.

    I assume you meant don't use the following -

    Reporting off log shipping secondary.

    Reporting off mirror DB.

    Reporting off Always On Read-only Secondary in SQL 2012.