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)
 Link tables in another database to create a view

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2005-12-29 : 11:10:33
How to add tables (link to, not import in) in another database to create a view?

nathans
Aged Yak Warrior

938 Posts

Posted - 2005-12-29 : 11:26:31
If the other database is on the same server just use fully qualified name to access.



Nathan Skerl
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-12-30 : 06:08:51
create a connection in the client network utility and then register the server in EM and you are up and running, there are a couple of examples in this forum
Go to Top of Page
   

- Advertisement -