Anyone with MS SQL server experience?

Open discussion about any topic, as long as you abide by the rules of course!
Post Reply
User avatar
Eraser
Posts: 19181
Joined: Fri Dec 01, 2000 8:00 am

Anyone with MS SQL server experience?

Post by Eraser »

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?
neh
Posts: 662
Joined: Mon Mar 12, 2001 8:00 am

Post by neh »

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 -
Post Reply