[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


view object in SQL Server 2005

Posted on 2007-10-20
Medium Priority
Last Modified: 2008-09-20
hi guys,

In a hurry, i am looking for a way to create a cross-database view in sql server 2005. Does sql provides something like that. Please provide me sample code. Infact i have to create such view for reconciliation b/w two databases'  tables on same server.

Question by:mfhorizon
1 Comment
LVL 18

Accepted Solution

PFrog earned 200 total points
ID: 20114386
You can reference other databases by using ..
i.e. a view called VW1 on a database called DB1 would be referenced as
This is actually DB1.dbo.VW1, but the dbo is assumed if it is left out

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Integration Management Part 2
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question