Connecting Tech Pros Worldwide Help | Site Map

Cannot specify an index or locking hint for a remote data source

Newbie
 
Join Date: Apr 2009
Posts: 28
#1: Jul 29 '09
Hi see if u could help me with the following

I am accessing a table which is on another DB.
But when I write Select LinkNo from ServerName.DBName.dbo.LinkMaster with(XLOck) where Linkid=25

It gives me the following error
Cannot specify an index or locking hint for a remote data source
May be the error is due to I m trying to lock a row which is on another server...Could someone suggest me any solution?
Reply