Can one create a view in MS SQL across databases

[WayneW]

I need to create a view of tables in 2 databases. Is this possible?

[mpg01]

You simply include the database names in the query

select <col>
from <database name>.<owner>.< table name>, <database name>.<owner>.< table name>, etc.

MG