Gettting list of Linked server configured in server using SQL Server


Contains a row per linked or remote server registered, and a row for the local server that has server_id = 0.

select * from sys.servers where server_id > 0

Local server that has server_id = 0, means currently running server.

select * from sys.servers where server_id = 0


Thanks :)