linked tables can only be created as views in ADP-- why?

[Randall Arnold]

Why when I create linked tables between 2 SQL server databases does the
recipient table show up as a view? Is there any way to force it to be a
table?

Randall Arnold

 

[Sylvain Lafontaine]

No, there is no way.

 

[Randall Arnold]

That seems like such a design flaw to me. It muddies the waters between
tables and views. Anyone have an idea what was behind such a lunatic
decision?

Randall Arnold

 

[Sylvain Lafontaine]

SQL-Server is a server, not a file server. With SQL-Server, you cannot make
a direct access to a table and you must retrieve any data by using a View, a
Query or a Stored Procedure. Linking a table from another server is limited
by the same considerations.

 

[Randall Arnold]

I understand what you're saying, but I still don't necessarily agree with
the result.

No matter... I'll reconstruct the tables in the recipient database and use
DTS packages to update them. I don't want all those misleading views.

Randall Arnold

 

[aaron.kempf]

shit bud

if you want to copy a database from one db to another; it's really easy

if you want to copy from one db server to another; that's still super
easy.

give us more information about what you're looking to do.

i think that there is an option when you import views to import them as
tables or views.

 

[aaron.kempf]

i meant to say 'table'

not database

it's easy to copy a table from one db to another; if that's really what
you want to do -- copy the table or view

i just wish that you'd explain more about what the problem is-- do you
want to update it and you can't do it since it's a view??

i love the linking functionality in ADP