Re: Allowing Fully Qualified Queries

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 12/05/04


Date: Sun, 5 Dec 2004 18:50:23 -0500

That is because you are referencing it incorrectly. It is not
Database.table but rather Database.own.table. If the owner is dbo you can
also substitute .. for dbo like this: YourDB..YourTable

Even when you are accessing objects int he same db you should get in the
habit of owner qualifying them lik:

SELECT * FROM dbo.Table

-- 
Andrew J. Kelly  SQL MVP
"Carlo Razzeto" <crazzeto@hotmail.com> wrote in message 
news:%23kgd5Py2EHA.1404@TK2MSFTNGP11.phx.gbl...
> Hello there, I recently installed MS SQL server on one of my servers and I 
> have a question. When preforming a select I'm supposed to be able to refer 
> to a database table in the from clause by it's fully qualified name 
> (database.table) eg.
>
> SELECT * FROM NorthWind.Customers;
>
> How ever if I attempt to preform this type of query I get the following 
> error back
>
> "Unknown object....".
>
> How can SQL Server be configured to allow me to specifiy a database table 
> by it's fully qualified name?
>
> Carlo Razzeto
> 


Relevant Pages

  • Re: Cannot view DB properties
    ... # Ran the setup and upgraded the existing SQL Server 8.00.818 to SQL Server ... owner was NULL after the UPgraded finished successfully. ... The proposed new database owner is already a user or aliased in the ... Sorry, I don't understand, what do you mean by "In-Place Upgrade"? ...
    (microsoft.public.sqlserver.security)
  • Re: HELP - I goofed when creating a database
    ... details) go to which date record - is not stored in your database; ... some reading on the merits of SQL Server vs Access. ... you select the owner or enter a new one, enter the date ordered, then ... ownerID - PK ...
    (comp.databases.ms-access)
  • Re: not creating tables as dbo anymore ?
    ... Database Owner (dbo) ... existing user ID in the database specified by database_name. ... with the login of the current connection. ...
    (microsoft.public.sqlserver.security)
  • Re: User names
    ... > With SP3 will tables created by upsizing from access also be dbo owned as ... >>dbo by default. ... byjust specifically giving the owner name in QA. ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Change UDF Owner
    ... Does it exist in the master database? ... Users can be put in the dbo role, but dbo will still own objects ... concept of 'schema' as 'owner' rather than just schema as DDL is exploited ... to the appropriate Fixed Server Roles or whatever is applicable. ...
    (microsoft.public.sqlserver.security)