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.
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(?) |
|
|
|
|
|