Create view from a different database 1

[JeanPhil]

Hi !

Is it possible to create a view in one database that is linked to another database.

I have a system with multiple companies which requires a database for each company. But I want to share a table for more than one database. Is there a way I can link a table from one database to another ?

 

[nigelrivett]

Depends which database you are using.
You may also get user permissions problems and will need to think about recovery strategies.

e.g. for sql server just reference the remote database

dbname..tblname

You can use unions (see partitioned views) to access all databases from a single view.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[JeanPhil]

Yeah thanks nigelrivett !!!

I use SQL Server with ASP code.

It was so obvious !!! Wow that help me A LOT !!!

Thanks again !!