Table of Contents

Class SqlServerGeneralProperties

Namespace
CENTREL.XIA.Configuration.Types
Assembly
CENTREL.XIA.Configuration.Types.dll

Represents the server general properties of a SQL instance.

public class SqlServerGeneralProperties : BaseTypeSection
Inheritance
SqlServerGeneralProperties

Constructors

SqlServerGeneralProperties()

Initializes a new instance of the CENTREL.XIA.Configuration.Types.SqlServerGeneralProperties class.

public SqlServerGeneralProperties()

Properties

ClusterName

Gets or sets the name of the cluster of which the instance is a member. This applies to on-premises SQL Server 2012 and above.

public string ClusterName { get; set; }

Property Value

string

ClusterNodeNames

Gets or sets the names of the cluster nodes.

public SerializableStringCollection ClusterNodeNames { get; set; }

Property Value

SerializableStringCollection

Collation

Gets or sets the collation of the instance.

public string Collation { get; set; }

Property Value

string

Edition

Gets or sets the edition of SQL Server.

public string Edition { get; set; }

Property Value

string

EngineType

Gets or sets the engine type.

public SqlDatabaseEngineType EngineType { get; set; }

Property Value

SqlDatabaseEngineType

EngineTypeString

Gets the engine type as a human readable string.

public string EngineTypeString { get; set; }

Property Value

string

InstanceName

Gets or sets the instance name.

public string InstanceName { get; set; }

Property Value

string

IsAzureHosted

Gets whether the server is Azure hosted.

public bool IsAzureHosted { get; }

Property Value

bool

IsClustered

Gets or sets whether the instance is clustered. This only applies to on-premises SQL Server installations.

public BooleanOption IsClustered { get; set; }

Property Value

BooleanOption

IsExpress

Gets or sets whether the server is running SQL Express Edition.

public BooleanOption IsExpress { get; set; }

Property Value

BooleanOption

IsFullTextInstalled

Gets or sets whether full-text search is installed on the server.

public BooleanOption IsFullTextInstalled { get; set; }

Property Value

BooleanOption

IsHadrEnabled

Gets or sets whether HADR (High Availability and Disaster Recovery) is enabled for the instance. This applies to on-premises SQL Server 2012 and above.

public BooleanOption IsHadrEnabled { get; set; }

Property Value

BooleanOption

IsNamedPipesEnabled

Gets or sets whether named pipes is enabled. This only applies to on-premises SQL Server installations.

public BooleanOption IsNamedPipesEnabled { get; set; }

Property Value

BooleanOption

IsTcpEnabled

Gets or sets whether TCP is enabled. This only applies to on-premises SQL Server installations.

public BooleanOption IsTcpEnabled { get; set; }

Property Value

BooleanOption

IsXTPSupported

Gets or sets whether XTP (Extreme Transaction Processing) is supported for the instance. This applies to SQL Server 2014 and above.

public BooleanOption IsXTPSupported { get; set; }

Property Value

BooleanOption

Language

Gets or sets the language of the instance. This only applies to on-premises SQL Server installations.

public string Language { get; set; }

Property Value

string

OperatingSystem

Gets or sets the operating system on which the instance is running. This only applies to on-premises installations of SQL Server.

public string OperatingSystem { get; set; }

Property Value

string

PhysicalMemory

Gets or sets the physical memory of the host. This only applies to on-premises installations of SQL Server.

public int PhysicalMemory { get; set; }

Property Value

int

Platform

Gets or sets the platform on which the instance is running. This only applies to on-premises installations of SQL Server.

public string Platform { get; set; }

Property Value

string

Processors

Gets or sets the number of processors available to the instance. This only applies to on-premises installations of SQL Server.

public int Processors { get; set; }

Property Value

int

Product

Gets the display name of the version.

public string Product { get; set; }

Property Value

string

ProductLevel

Gets or sets the product level - for example RTM.

public string ProductLevel { get; set; }

Property Value

string

RootDirectory

Gets or sets the root directory of the instance. This only applies to on-premises installations of SQL Server.

public string RootDirectory { get; set; }

Property Value

string

ServiceAccount

Gets or sets the service account name. This only applies to on-premises installations of SQL Server.

public string ServiceAccount { get; set; }

Property Value

string

ServiceStartMode

Gets or sets the start mode of the service. This only applies to on-premises installations of SQL Server.

public SqlServiceStartMode ServiceStartMode { get; set; }

Property Value

SqlServiceStartMode

ServiceStartModeString

Gets the start mode of the service. This only applies to on-premises installations of SQL Server.

public string ServiceStartModeString { get; set; }

Property Value

string

Version

Gets or sets the version of the SQL server.

public SerializableVersion Version { get; set; }

Property Value

SerializableVersion

VersionInformation

Gets the version information for the instance.

[Browsable(false)]
public SqlInstanceVersionInformation VersionInformation { get; }

Property Value

SqlInstanceVersionInformation

Methods

ToString()

Returns the general properties as a human readable string.

public override string ToString()

Returns

string

The general properties as a human readable string.