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 |
|
prabhu_mm
Starting Member
6 Posts |
 Posted - 2011-07-20 : 02:48:45
|
| Hi,Can u pls help me out this qry which i facing . Actually I need to access/connect some tables from local database on Qurey analyser .Usally we are using Server Ip Qurey analyser for retriving datas.Now I need to access my tables from local database to retive the data from server .Pls help me/ |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-20 : 06:32:19
|
| you might need to add the other server as a linked server to your local server where loacl db is present------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
prabhu_mm
Starting Member
6 Posts |
Posted - 2011-07-20 : 08:55:26
|
| Thank u vry much and one more help...can u explain , how to write a sql query on Linked server with where clause . |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
How to access/connect From Local Database