Re: max prefixes

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Phil (anonymous_at_discussions.microsoft.com)
Date: 03/23/04 

Date: Tue, 23 Mar 2004 15:21:18 -0800

keep in mind this is sql 6.5
select * from dbserver.pubs.dbo.authors
Thanks Steve!

>-----Original Message-----
>"phil" <anonymous@discussions.microsoft.com> wrote in
message
>news:120ce01c41100$32c21970$a401280a@phx.gbl...
>> The object name 'dbServer.pubs.dbo.authors' contains
more
>> than the maximum number of prefixes. The maximum is 2.
>>
>> when i tried selecting data from a linked server i get
>> this.
>
>That should be OK, provided 'dbServer' is the name of the
linked server...
>you could try leaving the dbo out, and let it default:
>'dbServer.pubs..authors'
>
>Also, paste your select statement.
>
>Steve
>
>
>.
>

Relevant Pages

  • Re: max prefixes
    ... How can we keep it in mind if you never told us? ... all you can do with a remote server (we didn't use the term ... linked server) is to call a stored procedure. ... SQL Server MVP ...
    (microsoft.public.sqlserver.connect)
  • RE: 0x80004005 - you need permission to view its data
    ... When creating the Access linked server, make sure the data source using UNC ... the SQL server(Both SQL authentication and Windows Authentication work). ... 262177 How to enable Kerberos event logging ...
    (microsoft.public.sqlserver.security)
  • Linked Servers - Real Post
    ... I am running SQL 2k on Win 2k. ... a front end for our SQL database. ... added the linked server I want, and SQL queries it fine, ... leaving the "local server login to remote server login" ...
    (microsoft.public.sqlserver.programming)
  • Linked Server - Issue
    ... I have to access a Linked Server S2 (SQL 2000). ... In S1 I have setup a linked server using sp_addlinkedserver pointing to S2. ... Both MyAccount and SpecialAccount has access permissions to S2. ... Reason Not associated with a Trusted SQL ...
    (microsoft.public.sqlserver.programming)
  • Re: Transfering only updated data (from as400 to SQL2000)
    ... Rifat, ... Create a linked server of the AS400. ... > will identify rows that require moving at ETL time. ... >> as400 to SQL. ...
    (microsoft.public.sqlserver.dts)