Creating Views from tables across Multiple Databases 2

[Mirak]

Hi,

I need some urgent assistance. I need to create views for a report, but the data that I need resides on different tables on two different databases on SQL Server. Is it possible to reference tables across databases. I know in MS Access its easy to link the tables and write the query, but I need for the query to reside on the server in a view. Is it possible to create the view using more than one databases....

thanks

 

[donutman]

You just 3-part qualify (out of 4) the table name:
TheDatabaseName.TheTableOwnerName.TheTableName and if you ever have to use multiple servers then add the linked server name to the beginning of that string.
-Karl

 

[SemperFiDownUnda]

This also works for linked servers to like Oracle or Sybase on other boxes.


Hope I've been helpful,
Wayne Francis

If you want to get the best response to a question, please check out FAQ222-2244 first