Linked server:Distributed query using hint with NOLOCK

donb 2017-04-03 04:29:28

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.
Aaron Bertrand 2017-04-11 21:13:27
NOLOCK doesn't actually mean no locking (see #6 here).