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 |
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
 Posted - 2005-06-13 : 05:18:16
|
| Hello everyone.i want to access the databases which are located at the different servers. is there any way to do so. something Like i have 2 servers. Server A and Server Bi am currently connected at server A and i want to write the query which will pick the value from the Server B using Query Analyser. i tried something like Select * From ServerB.Database.dbo.tab1but it gave me some error of sp_Addlinkserver........ThanksComplicated things can be done by simple thinking |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-06-13 : 05:29:20
|
| You need to add ServerB as Linked ServerRun thissp_addlinkedserver 'ServerB'and thenSelect * From ServerB.Database.dbo.tab1MadhivananFailing to plan is Planning to fail |
 |
|
|
vivek.kumargupta
Starting Member
45 Posts |
Posted - 2005-06-13 : 09:26:46
|
| You can do this through enterprise manager also under security folder ->linked serversThanks, Vivek |
|
|
|
|
|
|
Link Server