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

  • August 2, 2013 at 3:34 am

    #1638101

    kevin_nikolai (8/2/2013)

    For SQL Reports stored procedures you most definitely want to use "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED".

    --

    If you can guarantee that the database is and will be in a fully committed and unchanging state when the proc runs (eg if everything is in read-only mode), this should be OK. Otherwise Gail's advice is most pertinent.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.