Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Location
    Sunnyvale, CA USA
    Posts
    78

    Post Unanswered: isolation level for linked servers

    In Query Analyzer I'm using 'linked servers' to read from tables in another SQL Server instance (on another box). How can ensure that I'm getting "read uncommitted" isolation level?
    And does the same thing apply if I use 'linked servers' from osql?
    Thanks.

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    Look up "SET TRANSACTION ISOLATION LEVEL" in Books Online. Transaction level isolation is per connection so any server you connect to will need to honor the isolation level.

    The tool you use to conenct to your servers is for the most part irrelevent.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •