View data from another SQL Database

[AlunR]

Is it possible to create a view of a table from another Database. I'd like to be able to view the files but not be able to update them.

We have a third party DB and would like to be able to use another SQL db to store all our info.

 

[stsuing]

If it's on the same server just create a view and when you reference the other database use the full name
E.G.
Select *
From [OtherDatabase].[DBO].

ODT