Re: How many periods are REALLY needed?

Keith,

ServerName.DatabaseName.OwnerOrSchemaName.ObjectName make up the four
components for SQL Server names. If you are using a linked server you
should always have 3 dots involved when talking to another SQL Server.

But talking to Access, I don't know why behavior would have changed on you
even though Access is a different database. (More frankly, I don't know why
the .. worked.)

The 2000 and 2005 Books Online both say: Access databases do not have
catalog and schema names. Therefore, tables in an Access-based linked server
can be referenced in distributed queries using a four-part name of the form
linked_server...table_name.

RLF

"greenmtnsun" <greenmtnsun@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1A90E243-B0E5-43F4-AE44-E3291A5933FB@xxxxxxxxxxxxxxxx
I have a very strange situation. A select statement I am running isn't
returning the right number of records from a linked server.

The linked server is to an Access 2000 Database using the Microsoft Jet
4.0
OLE DB Provider driver. (4.0.9505.0)

Here is the problem:

SELECT * FROM PCCHARGE..TRANS -- This does not pull back todays data
judged
by looking at a column named "date".

SELECT * FROM PCCHARGE...TRANS -- This pulls back todays data, it pulls
back
all of the data.

What's the difference? the ... verses the ..

The .. was used by my predecessor in our SP's. They worked without any
known problems until today. Now all of the sudden, they don't do so well.
I
came to find out if you right click on the table in server objects and ask
SSMS to generate the select statement it gives ... periods.

So... Any idea what the problem is? What is the philosophy of periods
with
linked servers? How could they stop working?

Thanks,
Keith


.

Relevant Pages

  • Re:Application Role and access to other databases
    ... Since you are trying to connect to other SQL Server i do ... Refer to following links. ... >security and give users access to the database through ... >set up a linked server ok course! ...
    (microsoft.public.sqlserver.security)
  • Linked Server: Performance Issue with OpenQuery & SP best practices
    ... We are using the linked server feature of SQL Server 2000 to execute queries ... from the local database's stored procedure against the SQL Server database ... Please note that the schema of the remote database is different from the ...
    (microsoft.public.sqlserver.olap)
  • Re: Re:Application Role and access to other databases
    ... I need to figure out how to create a linked server. ... >>security and give users access to the database through ... > specifying the account ... >>The other database I can connect to as a SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: SELECT . . . ORDER BY - SQL 2000 vs. JET 4
    ... I've been working quite a bit lately with a Linked Server that actually hits ... If you set up the JET database as a Linked Server on the ... SQL server I am thinking that the sort order issue would be resolved because ... SQL would sort the JET database result set the same way it does the native ...
    (microsoft.public.sqlserver.programming)
  • RE: Linked server 7302 error
    ... button for each of the 'Access Permissions' ... the startup account for the SQL Server service is in the ... Microsoft Online Partner Support ... Under the linked server security tab, ...
    (microsoft.public.sqlserver.connect)
Loading