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 |
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
 Posted - 2008-04-25 : 09:43:43
|
| HI Guys,I just need to add multiple catalogs to the same linked server, in Sql Server 2000 or Sql Server 2005. Here i need only to add 3 databases in to a single linked server name.Thanks In Advance,Krishna |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-25 : 09:44:24
|
Why?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2008-04-25 : 09:47:38
|
| So that using that single Linked Server name , i will be able to access tables from all these tables alone.Thanks,Krishna |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-25 : 09:48:54
|
Yes it is possible with a VIEW.But why?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2008-04-25 : 09:50:18
|
| Just want to do a distributed query using the linked server.Thanks,KrishnaThanks & Best Regards,Krishna |
|
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2008-04-25 : 10:02:36
|
| Can you tell me how it is possible with a viewThanks & Best Regards,Krishna |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-25 : 21:56:21
|
| You can access all dbs on linked server as long as map user to correct sql login on linked server, just specify db name in the query like:select * from linked_server.db_name.schema.tab_name |
|
|
|
|
|
|
Multiple databases in single linked server ?