Class CompatibilitySchema.Server
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
sys.sysservers (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains one row for each server that an instance of SQL Server can access as an OLE DB data source.
important
This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead. To find the equivalent system view or views, see Mapping System Tables to System Views (Transact-SQL). This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
See sys.sysservers.
[Table(Schema = "sys", Name = "sysservers", IsView = true)]
public class CompatibilitySchema.Server- Inheritance
-
CompatibilitySchema.Server
- Extension Methods
Properties
Catalog
Catalog that is used when a connection is made to an OLE DB provider.
[Column("catalog")]
[Nullable]
public string? Catalog { get; set; }Property Value
Collation
Server collation as set by sp_serveroption@collation name.
[Column("collation")]
[Nullable]
public string? Collation { get; set; }Property Value
Collationcompatible
1 = sp_serveroption@collation compatible set to true or on.
0 = sp_serveroption@collation compatible set to false or off.
[Column("collationcompatible")]
[NotNull]
public bool Collationcompatible { get; set; }Property Value
Connecttimeout
Time-out setting for the server-connection.
[Column("connecttimeout")]
[Nullable]
public int? Connecttimeout { get; set; }Property Value
- int?
Dataaccess
1 = sp_serveroption@data access set to true or on.
0 = sp_serveroption@data access set to false or off.
[Column("dataaccess")]
[NotNull]
public bool Dataaccess { get; set; }Property Value
Datasource
OLE DB data source value.
[Column("datasource")]
[Nullable]
public string? Datasource { get; set; }Property Value
Dist
1 = sp_serveroption@dist set to true or on.
0 = sp_serveroption@dist set to false or off.
[Column("dist")]
[Nullable]
public bool? Dist { get; set; }Property Value
- bool?
Dpub
1 = sp_serveroption@dpub set to true or on.
0 = sp_serveroption@dpub set to false or off.
[Column("dpub")]
[Nullable]
public bool? Dpub { get; set; }Property Value
- bool?
Isremote
1 = Server is a remote server.
0 = Server is a linked server.
[Column("isremote")]
[Nullable]
public bool? Isremote { get; set; }Property Value
- bool?
Lazyschemavalidation
1 = sp_serveroption@lazy schema validation set to true or on.
0 = sp_serveroption@lazy schema validation set to false or off.
[Column("lazyschemavalidation")]
[NotNull]
public bool Lazyschemavalidation { get; set; }Property Value
Location
OLE DB location value.
[Column("location")]
[Nullable]
public string? Location { get; set; }Property Value
Nonsqlsub
0 = server is an instance of SQL Server
1 = server is not an instance of SQL Server
[Column("nonsqlsub")]
[Nullable]
public bool? Nonsqlsub { get; set; }Property Value
- bool?
Providername
OLE DB provider name for access to this server.
[Column("providername")]
[NotNull]
public string Providername { get; set; }Property Value
Providerstring
OLE DB provider string value.
[Column("providerstring")]
[Nullable]
public string? Providerstring { get; set; }Property Value
Pub
1 = sp_serveroption@pub set to true or on.
0 = sp_serveroption@pub set to false or off.
[Column("pub")]
[NotNull]
public bool Pub { get; set; }Property Value
Querytimeout
Time-out setting for queries against the server.
[Column("querytimeout")]
[Nullable]
public int? Querytimeout { get; set; }Property Value
- int?
Rpc
1 = sp_serveroption@rpc set to true or on.
0 = sp_serveroption@rpc set to false or off.
[Column("rpc")]
[NotNull]
public bool Rpc { get; set; }Property Value
Rpcout
1 = sp_serveroption@rpc out set to true or on.
0 = sp_serveroption@rpc out set to false or off.
[Column("rpcout")]
[NotNull]
public bool Rpcout { get; set; }Property Value
Schemadate
Date this row was last updated.
[Column("schemadate")]
[NotNull]
public DateTime Schemadate { get; set; }Property Value
Srvcollation
The collation of the server.
[Column("srvcollation")]
[Nullable]
public string? Srvcollation { get; set; }Property Value
Srvid
ID (for local use only) of the remote server.
[Column("srvid")]
[Nullable]
public short? Srvid { get; set; }Property Value
Srvname
Name of the server.
[Column("srvname")]
[NotNull]
public string Srvname { get; set; }Property Value
Srvnetname
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("srvnetname")]
[Nullable]
public string? Srvnetname { get; set; }Property Value
Srvproduct
Product name for the remote server.
[Column("srvproduct")]
[NotNull]
public string Srvproduct { get; set; }Property Value
Srvstatus
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
[Column("srvstatus")]
[Nullable]
public short? Srvstatus { get; set; }Property Value
Sub
1 = sp_serveroption@sub set to true or on.
0 = sp_serveroption@sub set to false or off.
[Column("sub")]
[Nullable]
public bool? Sub { get; set; }Property Value
- bool?
System
1 = sp_serveroption@system set to true or on.
0 = sp_serveroption@system set to false or off.
[Column("system")]
[NotNull]
public bool System { get; set; }Property Value
Topologyx
Not used.
[Column("topologyx")]
[Nullable]
public int? Topologyx { get; set; }Property Value
- int?
Topologyy
Not used.
[Column("topologyy")]
[Nullable]
public int? Topologyy { get; set; }Property Value
- int?
Useremotecollation
1 = sp_serveroption@remote collation set to true or on.
0 = sp_serveroption@remote collation set to false or off.
[Column("useremotecollation")]
[NotNull]
public bool Useremotecollation { get; set; }