nolocks on querys on remote servers

[olemma]

Is there a way to run a SELECT query on a table ona remote server with something a NOLOCK? I need something to make sure the query doesn't lock the table.

 

[olemma]

This is an example of what I'm trying to run, but it fails:

select * from s1.d1.dbo.t1 (nolock) a, s1.d1.dbo.t2 (nolock) b where a.f1=b.f1

 

[tlbroadbent]

What does the message say? I assume it says, "Cannot specify an index or locking hint for a remote data source." This is NOT permitted. However, you can use the hint when using OpenQuery to execute the query on the remote server.

Select *
from openquery(server2,'Select Name From HR.dbo.employees (nolock) where EmpID=1432') Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[olemma]

Thanks Terry...it seems that it will work for what I needed for.