Linked server queries.

pooja.budhrja_at_telnetww.com
Date: 08/31/04

  • Next message: John Scott: "Fixing a dll error" 
    Date: Tue, 31 Aug 2004 07:42:05 -0700

    I am working on SQL server 2000 and I am trying to write
    a stored procedure that runs a query using MS-Access 2000
    linked server.
    the error i am getting is :
    The object name 'compassdb...' contains more than the
    maximum number of prefixes. The maximum is 2.
    A part of the query is posted below:

    CREATE TABLE compassdb...qryPhoneNumberStartDate
    (PID as int, ISD datetime, startingdate datetime )

    insert into compassdb...qryPhoneNumberstartDate
    (PID , ISD , startingdate )
    SELECT a.PID, IsNull(b.BSD,b.ISD),b.BSD AS StartingDate
    FROM compassdb...Order_PhoneNumber a LEFT JOIN
    compassdb...Order_TrackingDates b
    ON (a.OIDStart = b.OID) AND (a.[IN] = b.[IN])

    Thanks,
    Pooja
     

  • Next message: John Scott: "Fixing a dll error"

    Relevant Pages

    • Re: CONTAINS performance
      ... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
      (microsoft.public.sqlserver.fulltext)
    • Re: Indexing Service, Openquery and sp_executesql
      ... SQL Server version and sp are you running? ... > data from the indexing service catalog when pasted into ... > query analyzer, but failed when put against sp_executesql ... I would choose Microsoft Indexing ...
      (microsoft.public.sqlserver.fulltext)
    • Re: Problem using Access or Query Designer to run queries in SQL Serve
      ... >or Query Designer within Enterprise Manager, it works and I get data back. ... >ODBC Call Failed [ODBC SQL Server Driver] Timeout Expirederror in Access ... >[ODBC SQL Server Driver] Timeout Expired ...
      (microsoft.public.sqlserver.odbc)
    • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
      ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Transaction Isolation Level
      ... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
      (comp.databases.ms-sqlserver)