Unanswered: Cannot specify an index or locking hint for a remote data source
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?