Posted by AlterEgo on 01/18/07 00:09

misscrf,

You can use a view to reference a table in another database as follows:

create view MyView as
select Column1, Column2 ...
from MyOtherDatabase.dbo.MyTable

--or to inherit the schema (owner) use:

from MyOtherDatabase..MyTable

Grant only read privledges on this view.

- Bill

"misscrf" <misscrf@yahoo.com> wrote in message
news:1169071836.030055.205600@a75g2000cwd.googlegroups.com...
> In a database, I am creating a new db. From there, I am setting up the
> tables, so that I can eventually create a front end (usually access,
> but I may attempt to be brave and lose the shell.) Anyway, I want to
> use a table, read-only for a lookup. It exists in another database on
> our system. Is there a way for me to link it into this database that I
> am working on? I would think of it like in access when you go to do a
> new table and you choose to link the table from somewhere else. That
> is what I want to do. Can anyone possibly step me through this?
> I know basics of sql server and like to learn.
>
> Thanks!
>

[Back to original message]