Solved

Linked Servers

Posted on 2008-10-13
4
165 Views
Last Modified: 2010-05-18
Is there a way to view what servers / ad are already linked in SQL 2005
0
Comment
Question by:jimseiwert
  • 2
4 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22707079
yes. in server objects -> linked servers.
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 22707100
in a query:

select * from master.sys.servers
where name <> @@SERVERNAME
0
 
LVL 24

Expert Comment

by:DBAduck - Ben Miller
ID: 22707103
And it should be available by executing

EXEC sp_helpserver

0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22707643
or:
select * from master.sys.sysservers
where srvid=0

All of these are viable approaches and points should be awarded to those who answered first.  srvid=0 is always the local server.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question