Contains a row per linked or remote server registered, and a row for the local server that has server_id = 0.
|
Column name
|
Data type
|
Description
|
|---|
|
server_id
|
int
|
Local ID of linked server.
|
|
name
|
sysname
|
When server_id = 0, this is the instance name.
When server_id >0 , this is the local name of linked server.
|
|
product
|
sysname
|
Product name of the linked server. "SQL Server" indicates this is another instance of SQL Server.
|
|
provider
|
sysname
|
OLE DB provider name for connecting to linked server.
|
|
data_source
|
nvarchar(4000)
|
OLE DB data source connection property.
|
|
location
|
nvarchar(4000)
|
OLE DB location connection property. NULL if none.
|
|
provider_string
|
nvarchar(4000)
|
OLE DB provider-string connection property.
Is NULL unless the caller has the ALTER ANY LINKED SERVER permission.
|
|
catalog
|
sysname
|
OLEDB catalog connection property. NULL if none.
|
|
connect_timeout
|
int
|
Connect time-out in seconds, 0 if none.
|
|
query_timeout
|
int
|
Query time-out in seconds, 0 if none.
|
|
is_linked
|
bit
|
0 = Is an old-style server added by using sp_addserver, with different RPC and distributed-transaction behavior.
1 = Standard linked server.
|
|
is_remote_login_enabled
|
bit
|
RPC option is set enabling incoming remote logins for this server.
|
|
is_rpc_out_enabled
|
bit
|
Outgoing (from this server) RPC is enabled.
|
|
is_data_access_enabled
|
bit
|
Server is enabled for distributed queries.
|
|
is_collation_compatible
|
bit
|
Collation of remote data is assumed to be compatible with local data if no collation information is available.
|
|
uses
_remote_collation
|
bit
|
If 1, use the collation reported by the remote server; otherwise, use the collation specified by the next column.
|
|
collation_name
|
sysname
|
Name of collation to use, or NULL if just use local.
|
|
lazy_schema_validation
|
bit
|
If 1, schema validation is not checked at query startup.
|
|
is_system
|
bit
|
This server can be accessed only by the internal system.
|
|
is_publisher
|
bit
|
Server is a replication Publisher.
|
|
is_subscriber
|
bit
|
Server is a replication Subscriber.
|
|
is_distributor
|
bit
|
Server is a replication Distributor.
|
|
is_nonsql_subscriber
|
bit
|
Server is a non-SQL Server replication Subscriber.
|
|
modify_date
|
datetime
|
Date server information was last changed.
|