[dba-SQLServer]Two Databases, One Server

Nicholson, Karen knicholson at gpsx.net
Wed Dec 24 12:57:12 CST 2003


Yep, it is pretty slicko.. thanks.

-----Original Message-----
From: Arthur Fuller [mailto:artful at rogers.com]
Sent: Wednesday, December 24, 2003 4:41 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Two Databases, One Server


I have two copies of Northwind installed, one called Northwind and my
customizations to it called NorthwindCS. Running QA and selecting
NorthwindCS first....

Select * from Customers
inner join Northwind.dbo.Orders on Customers.CustomerID =
Northwind.dbo.Orders.CustomerID

Works fine.

HTH,
Arthur

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
Nicholson, Karen
Sent: Wednesday, December 24, 2003 7:35 AM
To: Dba-Sqlserver (E-mail)
Subject: [dba-SQLServer]Two Databases, One Server


Is it possible to create a view using tables from two different
databases that reside on one server?
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


More information about the dba-SQLServer mailing list