---
description: "sys.servers (Transact-SQL)"
title: "sys.servers (Transact-SQL) | Microsoft Docs"
ms.custom: ""
ms.date: "06/16/2020"
ms.prod: sql
ms.prod_service: "database-engine"
ms.reviewer: ""
ms.technology: system-objects
ms.topic: "reference"
f1_keywords: 
  - servers_TSQL
  - sys.servers_TSQL
  - servers
  - sys.servers
dev_langs: 
  - "TSQL"
helpviewer_keywords: 
  - "sys.servers catalog view"
ms.assetid: 4e774ed9-4e83-4726-9f1d-8efde8f9feff
author: WilliamDAssafMSFT
ms.author: wiassaf
monikerRange: "=azuresqldb-mi-current||>=sql-server-2016||>=sql-server-linux-2017"
---
# sys.servers (Transact-SQL)
[!INCLUDE [SQL Server - ASDBMI](../../includes/applies-to-version/sql-asdbmi.md)]

  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, the returned value is the server name.<br /><br /> When **server_id** > 0, the returned value is the local name of linked server.|  
|**product**|**sysname**|Product name of the linked server. A value of "SQL Server" indicates another instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].|  
|**provider**|**sysname**|OLE DB provider name for connecting to linked server.<br /><br />Starting with [!INCLUDE[sql-server-2019](../../includes/sssql19-md.md)], the value "SQLNCLI" maps to the [Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL)](../../connect/oledb/oledb-driver-for-sql-server.md) by default. In earlier versions, the value "SQLNCLI" maps to the [SQL Server Native Client OLE DB provider (SQLNCLI11)](../../relational-databases/native-client/sql-server-native-client.md).|  
|**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.<br /><br /> Is NULL unless the caller has the `ALTER ANY LINKED SERVER` permission.|  
|**catalog**|**sysname**|OLE DB 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.<br /><br /> 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.|  
|**is_remote_proc_transaction_promotion_enabled**|**bit**|If 1, calling a remote stored procedure starts a distributed transaction and enlists the transaction with MS DTC. For more information, see [sp_serveroption &#40;Transact-SQL&#41;](../../relational-databases/system-stored-procedures/sp-serveroption-transact-sql.md).|  
|**modify_date**|**datetime**|Date that server information was last changed.|  
|**is_rda_server**|**bit**|**Applies to:** Starting with [!INCLUDE[sssql16-md](../../includes/sssql16-md.md)].<br /><br />Server is remote data archive enable (stretch-enabled). For more information, see [Enable Stretch Database on the server](../../sql-server/stretch-database/enable-stretch-database-for-a-database.md#EnableTSQLServer).|
  
## Permissions  
 The value in **provider_string** is always NULL unless the caller has the ALTER ANY LINKED SERVER permission.  
  
 Permissions are not required to view the local server (**server_id** = 0).  
  
 When you create a linked or remote server, [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] creates a default login mapping to the **public** server role. Default login mapping means that all logins can view all linked and remote servers. To restrict visibility to these servers, remove the default login mapping by executing [sp_droplinkedsrvlogin](../../relational-databases/system-stored-procedures/sp-droplinkedsrvlogin-transact-sql.md) and specifying NULL for the *locallogin* parameter.  
  
 If the default login mapping is deleted, only users that have been explicitly added as a linked login or remote login can view the linked or remote servers for which they have a login.  The following permissions are required to view all linked and remote servers after the default login mapping:  
  
- `ALTER ANY LINKED SERVER` or `ALTER ANY LOGIN ON SERVER`  
- Membership in the **setupadmin** or **sysadmin** fixed server roles  
  
## See Also  
 [Catalog Views &#40;Transact-SQL&#41;](../../relational-databases/system-catalog-views/catalog-views-transact-sql.md)   
 [Linked Servers Catalog Views &#40;Transact-SQL&#41;](../../relational-databases/system-catalog-views/linked-servers-catalog-views-transact-sql.md)   
 [sp_addlinkedsrvlogin &#40;Transact-SQL&#41;](../../relational-databases/system-stored-procedures/sp-addlinkedsrvlogin-transact-sql.md)   
 [sp_addremotelogin &#40;Transact-SQL&#41;](../../relational-databases/system-stored-procedures/sp-addremotelogin-transact-sql.md)