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 |
|
leedoolan
Starting Member
12 Posts |
 Posted - 2002-06-26 : 05:15:38
|
| Is there any way you can access another server in scripts/query analyser? i.e. something like servername.dbname.dbo.tablename etc.And if so is it possible to connect to non-sql servers in this way?Thanks in advance, and I apologise if I appear a little naive. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-06-26 : 05:51:02
|
| yeah, look up sp_addlinkedserver...PeaceRick |
 |
|
|
MakeYourDaddyProud
184 Posts |
Posted - 2002-06-26 : 05:59:43
|
| Remember that you can't run sp_addlinkedserver to link a local sql server to itself. This tends to happen when developers want to a multi-server scenario on one box...Dan<<monet makes money>> |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-06-26 : 07:18:14
|
Dan,quote:
Remember that you can't run sp_addlinkedserver to link a local sql server to itself
but that's not what he asked!!!  PeaceRick |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-26 : 08:18:35
|
quote:
Remember that you can't run sp_addlinkedserver to link a local sql server to itself.
Ummmm, I just did it on my server. Twice. |
|
|
|
Funkabubble
Starting Member
3 Posts |
Posted - 2002-07-15 : 09:35:52
|
| Is there an equivilent in MS SQL 6.5? sp_addlinkedserver doesn't work on my servers?Cheers |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-15 : 09:38:41
|
| Linked servers were introduced with SQL 7.0, so you'd need at least 7.0 to create one. If you have a SQL 7.0 or 2000 server however, you can create a linked server to the 6.5 box. |
|
|
|
Funkabubble
Starting Member
3 Posts |
Posted - 2002-07-15 : 09:41:02
|
| Thanks very much for that help, I have been scratching my brains for a couple of hours over that one as I can't find anything about it in any documentation I have. At least I can give my boss a definate answer.cheers. |
|
|
|
|
|
|
Accessing other server connection?