Nicholson, Karen
knicholson at gpsx.net
Wed Dec 24 11:43:41 CST 2003
I figured it out. Monitordb.dbo.alarm_incident (preface with the database name, owner and the table needed). -----Original Message----- From: DJK(John) Robinson [mailto:djkr at msn.com] Sent: Wednesday, December 24, 2003 12:40 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]Two Databases, One Server Yes. John > -----Original Message----- > From: dba-sqlserver-bounces at databaseadvisors.com > [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf > Of Nicholson, Karen > Sent: 24 December 2003 15:35 > 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