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 |
|
spareus
Yak Posting Veteran
52 Posts |
 Posted - 2011-09-02 : 11:09:21
|
| I am using old version of the sql server 2000 where there is a limit of 2gb on size (includes all db put together)I have around 11 tables and my queries uses 5-6 tables joins to get the result sets.Is it possible to have each table in a saperate instance of sql server and then join them to get the results?Regards,Regards,Spareus |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-02 : 12:46:54
|
| you can do that. but for fetching tables you need to use linked servers.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
spareus
Yak Posting Veteran
52 Posts |
Posted - 2011-09-06 : 02:32:38
|
| I dont need to fatch whole tables. I nned to join them and use quary to get the resultent records.But how can join server1.db1.table1withserver2.db2.table2Pl help, Iam quite new in this area.Regards,Regards,Spareus |
|
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2011-09-06 : 02:36:01
|
quote:
Originally posted by spareus
I dont need to fatch whole tables. I nned to join them and use quary to get the resultent records.But how can join server1.db1.table1withserver2.db2.table2Pl help, Iam quite new in this area.Regards,you need to create linked server of all those instance to the server from which you are going to Query. after creating linked server you can query the tables and use them in join. Regards,Spareus
Karthikhttp://karthik4identity.blogspot.com/ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
How to use multiple server db/tables in views