Post reply

SET TRANSACTION ISOLATION LEVEL

  • April 24, 2008 at 1:18 pm

    #71486

    Will "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" apply to queries made against a Linked Server (remote SQL Server)?

    Thanks!

  • April 24, 2008 at 5:12 pm

    #806930

    I have done this in a SQL 2005 to SQL 2005 configuration and it worked as expected, using READ UNCOMMITTED. There are some restrictions with other isolation levels, so you'll have to test well before rolling it out to production.

    I have not attempted this or WITH (NOLOCK) in a SQL 2000 environment in so long that I don't recall if it works correctly there.

    Depending on your environment, you may find it better to setup views on the remote server that use the NOLOCK/READUNCOMMITTED table hints.

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

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