working with 2 databases

[121278]

can anyone tell me how i can solve this problem?

i connect to a database, make a select from a table in this db and a view which points to table in another db,
which is not workin
(i guess because i didn't connect to the 2nd db)
selecting things just from one db works

how can i solve this problem?
stored procedures didn't help

thanx for answers in advance
ca

 

[vasah20]

are the databases on the same server?

if so, to reference different tables in different databases you need to fully qualify the name.

this question will better be answered in the SQL Server forum, but if I recall right, I think you fully qualify the tables as such:

DatabaseName..tableName

where the .. defaults you to DBO... I could be wrong though...

hth
leo