Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 View with 2 joint tables from Different DB

Author  Topic 

Fatalsniper
Starting Member

45 Posts

Posted - 2005-08-26 : 14:19:27
Hey there,

Is there a way to create a view that contains two joint tables from different databases. and if so, Where would that view(object) be created/located.(which DB or it'd be a sysobject?)?

Thank you in advance!

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-08-26 : 14:31:45
either DB but most likely the one that the app that needs to use it is logged into. you would then qualify the outside table with with the 3 part name...

database.owner.table.

There are some issues with doing stuff like this. something cross database ownership chaining or permissions or something. Too tired... Head might fall into the monitor...

====================================================
Regards,
Sean Roussy

"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?)
Go to Top of Page
   

- Advertisement -