Solved

Linked Servers

Posted on 2008-10-13
4
164 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 142

Expert Comment

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

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql calculate reminders 11 73
How to PARSE a text field that is delimited by '~' character? 3 61
sql Audit table 3 66
SQL query to summarize items per month 5 59
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

785 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