Linked server:Distributed query using hint with NOLOCK

I would like to know if a linked server distributed query with hint NOLOCK is actually using the hint? I observed a schema-stability lock while using both normal and distributed query and wanted to confirm if it is a true statement.

avatar image By donb 1 asked Apr 03 at 04:29 AM
more ▼
(comments are locked)
avatar image Aaron Bertrand ♦ Apr 11 at 09:13 PM

NOLOCK doesn't actually mean no locking (see #6 here).

10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x5

asked: Apr 03 at 04:29 AM

Seen: 35 times

Last Updated: Apr 11 at 09:13 PM