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 |
|
mparter
Yak Posting Veteran
86 Posts |
 Posted - 2002-05-08 : 19:01:33
|
| I'm trying to setup a linked server in SQL Server and as I've never done this before I'm totally lost. All the documentation I find is too confusing!Basically I have an Oracle database on another server and I want to link to it so I can use one of the tables on it. When I try to set this up using the Enterprise manager I don't get anywhere. I'm not sure what exactly to put in the boxes in the dialog box asking you for setup details.This is probably so easy once you've done it once!Thanks in advance,Mark |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-05-08 : 19:12:56
|
| Don't use Enterprise Manager, it's quite confusing. Instead, open SQL Server Books Online and use the example provided in the documentation of sp_addlinkedserver.After that run sp_addlinkedsrvlogin.--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
mparter
Yak Posting Veteran
86 Posts |
Posted - 2002-05-08 : 19:17:34
|
| Thanks, how do you actually run the stored procedure 'sp_addlinkedserver'? As you can tell I'm struggling here :) |
|
|
|
|
|
|
Need help with linked server