view object in SQL Server 2005

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.

Who is Participating?
PFrogConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.