Export (0) Print
Expand All

IServerInformation Interface

An interface based on the Information type properties.

This API is not CLS-compliant. 

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

'Declaration
<DisplayDescriptionKeyAttribute("IServerInformation_Desc")> _
<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")> _
<DisplayNameKeyAttribute("IServerInformation_Name")> _
<RootFacetAttribute(GetType(Server))> _
<CLSCompliantAttribute(False)> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<TypeConverterAttribute(GetType(LocalizableTypeConverter))> _
Public Interface IServerInformation _
	Inherits IDmfFacet
'Usage
Dim instance As IServerInformation

The IServerInformation type exposes the following members.

  NameDescription
Public propertyBuildClrVersionStringGets the CLR build version string for the instance of SQL Server.
Public propertyBuildNumberGets the build number for the instance of SQL Server.
Public propertyCollationGets the collation information for the instance of SQL Server.
Public propertyCollationIDGets the collation identifier for the instance of SQL Server.
Public propertyComparisonStyleGets the comparison style for the instance of SQL Server.
Public propertyComputerNamePhysicalNetBIOSGets the host computer physical NetBIOS name.
Public propertyEditionGets the edition of the instance of SQL Server.
Public propertyEngineEditionGets the SQL Server Engine edition as an edition object.
Public propertyErrorLogPathGets the error log path for the instance of SQL Server.
Public propertyIsCaseSensitiveGets a value that indicates whether the server uses case-sensitive.
Public propertyIsClusteredGets a value that indicates whether the instance of SQL Server is clustered.
Public propertyIsFullTextInstalledGets a value that indicates whether the Full-Text is installed on the instance of SQL Server.
Public propertyIsHadrEnabledGets a value that indicates whether the Hadr is enabled.
Public propertyIsSingleUserGets a value that indicates whether the instance of SQL Server is read-only.
Public propertyIsXTPSupportedGets whether XTP is supported with this interface.
Public propertyLanguageGets the SQL Server language.
Public propertyMasterDBLogPathGets the master database log path for the instance of SQL Server.
Public propertyMasterDBPathGets the master database data path for the instance of SQL Server.
Public propertyMaxPrecisionGets the greatest decimal precision available for exact numeric data types (not floating point), including decimal and numeric.
Public propertyNetNameGets the network name for an instance of SQL Server.
Public propertyOSVersionGets the host computer operating system version.
Public propertyPhysicalMemoryGets the total RAM installed, in MB, for the computer that is running the instance of SQL Server.
Public propertyPlatformGets the hardware platform for the computer that is running the instance of SQL Server.
Public propertyProcessorsGets the number of processors that are installed on the computer that is running the instance of SQL Server.
Public propertyProductGets the product title for the instance of SQL Server.
Public propertyProductLevelGets the product level for the instance of SQL Server.
Public propertyResourceLastUpdateDateTimeGets a DateTime object that specifies the last time the resource database was updated.
Public propertyResourceVersionStringGets the version of the SQL Server resource in string format.
Public propertyRootDirectoryGets the root directory for the instance of SQL Server.
Public propertySqlCharSetGets the SQL character set ID from the collation ID as a tinyint.
Public propertySqlCharSetNameGets the SQL character set name from the collation.
Public propertySqlSortOrderGets the SQL sort order ID from the collation.
Public propertySqlSortOrderNameGets the SQL sort order name from the collation.
Public propertyVersionMajorGets the portion of a component version identifier to the left of the first decimal point in the identifier.
Public propertyVersionMinorGets the portion of a component version identifier to the right of the first decimal point in the identifier.
Public propertyVersionStringGets the date, version, and processor type of the instance of SQL Server.
Top

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Community Additions

ADD
Show:
© 2014 Microsoft