Nolock not working inside linked query

Question

I am trying to access a linked query with (nolock) option, but it is throwing me error, below is my query.

SELECT * FROM openquery(testengine , 'SELECT * FROM employee WITH(nolock)')

The following error is returned:

an error occurred while preparing the query "my query" for execution against OLEDB provider "ORAOLEDB.oracle" for linked server

Answer 1

From your error message, it looks like the linked server is Oracle. OPENQUERY queries are executed on the target server, and so must be written in the SQL dialect of the target system.

NOLOCK is not supported Oracle syntax - hence the error.