By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,092 Members | 1,546 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,092 IT Pros & Developers. It's quick & easy.

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

P: 31
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?
Jul 29 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.