Mike & Doris Manning
mikedorism at adelphia.net
Sat Aug 7 14:51:08 CDT 2004
The syntax is database.dbo.object You can do same with a table, view, sproc, or function Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Saturday, August 07, 2004 3:42 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Calling Views From another Database but applyingthem to THIS database I have been reading a thread on this subject in one of the many SQL lists I subscribe to. I scanned the recent emails and cannot find the thread here, so it may have hit me from another list. Point is, I think that I have figured out how to do it. So if the question did in fact arise on this list, would the question-poser please reply so that I can send a test query to confirm or deny that my solution works? TIA, Arthur _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com