April 28, 2005 at 10:41 am
Hi,
I have a link server. A procedure is scheduled on local server to run every few minuts to bring data from a remote server to local server.
We need to use (NOLOCK) hint on a select query, like
Select * From RemoteServer.DBname.dbo.Customer (Nolock)
Where status = 'N'
And customer_id = 1234
But (Nolock) is not allowed from SqlServer.
We want to create a view on RemoteServer with (Nolock):
Create View v_Customer
As
Select * From Customer (Nolock)
Where status = 'N'
Then, on the local server, use
Select * From RemoteServer.DBname.dbo.v_Customer
Where customer_id = 1234
( 1234 here is actually a parameter to pass in )
I am wondering if the (Nolock) hint is really taking effect ?
Thank You !
April 28, 2005 at 1:17 pm
I believe that lock hints are ignored on link server queries, as such your nolock is not having any effect.
Creating the view the way that you are however should force the hint to be observed.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply