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