Quake3World

Does anyone know if it's possible to create a view that gathers data from different databases (within the same instance of MS SQL server)? Or is that only possible on different tables within the same database?

use openrowset or openquery - you can use either a linked server or any valid oledb datasource via a connection string depending on which you use -