Post reply

Users and Isolation Level

  • October 27, 2006 at 3:49 am

    #91922

    We have a DB which some users want to access on a readonly basis from Excel.

    As we do not currently have enough space to duplicate the DB, I was wondering if there is a way to force the default isolation level for a particular user to READUNCOMMITTED instead of READCOMMITTED?

    I presume the alternative is to get each user to connect with an IsolationLevel property of  adXactReadUncommitted. I suspect this would be difficult to enforce.

    Any ideas gratefully received!

  • October 27, 2006 at 9:42 am

    #668543

    I think this can be done by creating a db that only consists of VIEWs of the tables in the main db. All the SELECTs in the VIEWs will have the (NOLOCK) hint.

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply