Re: Linked server problems

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 11/09/03

  • Next message: Allan Mitchell: "Re: Finding SQL Servers and Patch levels on a network" 
    Date: Sun, 9 Nov 2003 22:55:23 -0000

    How are you posting the query? Are you using 4 part naming? Have you tried
    OPENQUERY? 

    -- 
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Bob Frasca" <bfrasca@netspoke.com> wrote in message
news:ersLPfUpDHA.1740@TK2MSFTNGP12.phx.gbl...
> I posted this on the "programming" group but no one has responded.
Thought
> I'd try here...
>
> I have heard rumors that certain queries to linked servers will not
utilize
> indexes on the linked server.  In my case, I am trying to update records
in
> a table on a linked server and it will not use the index despite the fact
> that I am referring to the primary key.  When I take the same query and
run
> it on the linked server directly it works fine.
>
> Does anyone know if this is documented anywhere?  My workaround is to move
> the query to a stored procedure on the linked server and then call the
> stored procedure on the linked server rather than a straight UPDATE
> statement.  This works but it would be nice to know WHEN I'm going to have
> to use this type of work around.
>
>
>
  • Next message: Allan Mitchell: "Re: Finding SQL Servers and Patch levels on a network"

    Relevant Pages

    • Re: Discussing 3 different strategies for deleting from multiple tables
      ... I will be using SQL Server but I am riding on top of a third party ... FYI, Account contains around 20K ... >>> This results in one parameterized query followed by two more trips to ...
      (microsoft.public.data.ado)
    • Re: Efficient coordinated queries??
      ... :-) We are distributing processing over a large server farm -- bringing it back onto the SQL server would probably kill our performance. ... Hitchhiker's Guide to Visual Studio and SQL Server ... A large chunk of it can be brought in with a single query and each row represents an item to process. ... For a hypothetical example consider a customer order database where we need to process through all customers and can bring in a row of customer data as our main query but there are 0..n1 rows of customer order data, 0..n2 rows of customer feedback information, 0..n3 rows of customer discounts available, etc. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: T-SQL is not quite there yet
      ... StoredProc1 does the same thing to insert data from StoredProc2. ... I assume a lot of this has to do with that the linked server may not ... SQL Server instance, one could surely wish that SQL Server had special ...
      (microsoft.public.sqlserver.programming)
    • Re: Calculated field in pass through query
      ... Using the same hardware, with a single user, Jet will be faster than MS SQL ... Server simply because Jet does not use log. ... Even within MS SQL Server, ... same query on the same data but on another MSSQL db, ...
      (microsoft.public.access.queries)
    • Re: Website Connectivity?
      ... does the website just query our server? ... How do I give it a login to query the SQL Server running on the server? ... It would be a serious security breach to allow a remote website to ...
      (microsoft.public.windows.server.sbs)
    • Quantcast