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 :)