View - Tables in more than one database? 2

[Ralph8]

For a new version of my program, I have split the DB into two databases. The view of concern now uses 8 fields in a table in one DB and two fields in two tables in the other DB. The view now will not see the latter two fields in the second DB.

I am using SQL Server 7 in VS 6.

Is there a way to do this? I have checked the FAQs and searched other sources with no answers so far.

TIA

Ralph

TIA

Ralph D. Meredith

http://www.merecosoftware.com

 

[MatthewPeters]

try something like . . .

select field1, field2, field3
from DataBaseName.dbo.TableName

that should work for you

 

[Ralph8]

That looks like it should work. Does Enterprise Manager have the capability to do this relative to the "Add Table" in the View Designer. It is not a problem to modify the generated code. I was just wondering if I have been overlooking something?

Thanks. I will confirm when I try this.

Ralph

TIA

Ralph D. Meredith

http://www.merecosoftware.com

 

[JamesLean]

One tip - don't use Enterprise Manager to create views! Write a CREATE VIEW script in Query Analyzer and execute that. EM has limitations as to what you can do when creating views.

--James