Table of Contents

Class LinkedServersSchema.Server

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.servers (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Managed Instance

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


See sys.servers.

[Table(Schema = "sys", Name = "servers", IsView = true)]
public class LinkedServersSchema.Server
Inheritance
LinkedServersSchema.Server
Extension Methods

Properties

Catalog

OLE DB catalog connection property. NULL if none.

[Column("catalog")]
[Nullable]
public string? Catalog { get; set; }

Property Value

string

CollationName

Name of collation to use, or NULL if just use local.

[Column("collation_name")]
[Nullable]
public string? CollationName { get; set; }

Property Value

string

ConnectTimeout

Connect time-out in seconds, 0 if none.

[Column("connect_timeout")]
[Nullable]
public int? ConnectTimeout { get; set; }

Property Value

int?

DataSource

OLE DB data source connection property.

[Column("data_source")]
[Nullable]
public string? DataSource { get; set; }

Property Value

string

IsCollationCompatible

Collation of remote data is assumed to be compatible with local data if no collation information is available.

[Column("is_collation_compatible")]
[NotNull]
public bool IsCollationCompatible { get; set; }

Property Value

bool

IsDataAccessEnabled

Server is enabled for distributed queries.

[Column("is_data_access_enabled")]
[NotNull]
public bool IsDataAccessEnabled { get; set; }

Property Value

bool

IsDistributor

Server is a replication Distributor.

[Column("is_distributor")]
[Nullable]
public bool? IsDistributor { get; set; }

Property Value

bool?

IsLinked

0 = Is an old-style server added by using sp_addserver, with different RPC and distributed-transaction behavior.

1 = Standard linked server.

[Column("is_linked")]
[NotNull]
public bool IsLinked { get; set; }

Property Value

bool

IsNonsqlSubscriber

Server is a non-SQL Server replication Subscriber.

[Column("is_nonsql_subscriber")]
[Nullable]
public bool? IsNonsqlSubscriber { get; set; }

Property Value

bool?

IsPublisher

Server is a replication Publisher.

[Column("is_publisher")]
[NotNull]
public bool IsPublisher { get; set; }

Property Value

bool

IsRdaServer

Applies to: Starting with SQL Server 2016 (13.x).

Server is remote data archive enable (stretch-enabled). For more information, see Enable Stretch Database on the server.

[Column("is_rda_server")]
[Nullable]
public bool? IsRdaServer { get; set; }

Property Value

bool?

IsRemoteLoginEnabled

RPC option is set enabling incoming remote logins for this server.

[Column("is_remote_login_enabled")]
[NotNull]
public bool IsRemoteLoginEnabled { get; set; }

Property Value

bool

IsRemoteProcTransactionPromotionEnabled

If 1, calling a remote stored procedure starts a distributed transaction and enlists the transaction with MS DTC. For more information, see sp_serveroption (Transact-SQL).

[Column("is_remote_proc_transaction_promotion_enabled")]
[Nullable]
public bool? IsRemoteProcTransactionPromotionEnabled { get; set; }

Property Value

bool?

IsRpcOutEnabled

Outgoing (from this server) RPC is enabled.

[Column("is_rpc_out_enabled")]
[NotNull]
public bool IsRpcOutEnabled { get; set; }

Property Value

bool

IsSubscriber

Server is a replication Subscriber.

[Column("is_subscriber")]
[Nullable]
public bool? IsSubscriber { get; set; }

Property Value

bool?

IsSystem

This server can be accessed only by the internal system.

[Column("is_system")]
[NotNull]
public bool IsSystem { get; set; }

Property Value

bool

LazySchemaValidation

If 1, schema validation is not checked at query startup.

[Column("lazy_schema_validation")]
[NotNull]
public bool LazySchemaValidation { get; set; }

Property Value

bool

Location

OLE DB location connection property. NULL if none.

[Column("location")]
[Nullable]
public string? Location { get; set; }

Property Value

string

ModifyDate

Date that server information was last changed.

[Column("modify_date")]
[NotNull]
public DateTime ModifyDate { get; set; }

Property Value

DateTime

Name

When server_id = 0, the returned value is the server name.

When server_id > 0, the returned value is the local name of linked server.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

Product

Product name of the linked server. A value of 'SQL Server' indicates another instance of SQL Server.

[Column("product")]
[NotNull]
public string Product { get; set; }

Property Value

string

Provider

OLE DB provider name for connecting to linked server.

Starting with SQL Server 2019 (15.x), the value 'SQLNCLI' maps to the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) by default. In earlier versions, the value 'SQLNCLI' maps to the SQL Server Native Client OLE DB provider (SQLNCLI11).

[Column("provider")]
[NotNull]
public string Provider { get; set; }

Property Value

string

ProviderString

OLE DB provider-string connection property.

Is NULL unless the caller has the ALTER ANY LINKED SERVER permission.

[Column("provider_string")]
[Nullable]
public string? ProviderString { get; set; }

Property Value

string

QueryTimeout

Query time-out in seconds, 0 if none.

[Column("query_timeout")]
[Nullable]
public int? QueryTimeout { get; set; }

Property Value

int?

ServerID

Local ID of linked server.

[Column("server_id")]
[NotNull]
public int ServerID { get; set; }

Property Value

int

UsesRemoteCollation

If 1, use the collation reported by the remote server; otherwise, use the collation specified by the next column.

[Column("uses_remote_collation")]
[NotNull]
public bool UsesRemoteCollation { get; set; }

Property Value

bool