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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 07/06/04 

Date: Tue, 6 Jul 2004 11:26:13 -0400

Can you not create a stored procedure on the remote data source that
specifies the hint? 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"John Williams" <anonymous@discussions.microsoft.com> wrote in message
news:27f3501c4636b$941fa990$a301280a@phx.gbl...
> We are migrating from sql 7 to sql 2000 and for the time
> being leaving the database in sql 7 compatabiliy mode.
> Some of the stored procedures reference the tables on a
> linked server. The linked server is running sql 2000 and
> the database is sql 2000.
>
> When I run the following command
> select * from linked_server.database.dbo.tablename (nolock)
>
> I receive the following error
> Cannot specify an index or locking hint for a remote data
> source.
>
> If I remove the () around nolock the statement runs.
>
> The question(s) I have
>
> 1. Did I set something up wrong?
> 2. Without the () is the nolock still performing the same
> function?
> 3. Assumining I did not error on the configuration, Why do
> I receive this error now, and not before?
> 4. Any ideas to fix the problem without removing the ()?
>
> Thanks in advance for any suggestions/ideas.
>
> John Williams

Relevant Pages

  • Re: Forcing index usage...
    ... I'm in a situation where oracle spatial doesn't use a domain index even if I use the index hint. ... But as soon as I add more predicates or nest the query into another one, ... Could you give us an example of the SQL ... Complete with execution plans. ...
    (comp.databases.oracle.server)
  • Re: Retrieve data from SQL and post to AccessDatabase
    ... You need to look into your SQL Server's INSERT INTO syntax. ... Inserting a Row Using INSERT...Values ... The VALUES keyword specifies the values for one row of a table. ... You need to build a VB string that holds this type of string: ...
    (comp.lang.basic.visual.database)
  • Re: JDBC literals
    ... two single quotes to indicate embedded quotes. ... This is not true for all SQL DBMS vendors, ... specifies the interval being used in the calculation. ...
    (comp.lang.java.databases)
  • SQL Generator
    ... I am writing a little parser that generates valid SQL using ... product_filter specifies the product type to be included in the search ... funcname is an aggregate function ... I would like to know what the underlying SQL statement will look like, ...
    (comp.databases.ms-sqlserver)
  • Re: Need help with hint syntax in SQL Server 2000
    ... the tables in the view but will an index hint propogate or will I have ... SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx ... The query was a simple query against a view: ... When I coded the index hint the SQL Server plan showed it being used ...
    (comp.databases.ms-sqlserver)