Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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)
[CLSCompliantAttribute(false)]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[DisplayNameKeyAttribute("IServerInformation_Name")]
[DisplayDescriptionKeyAttribute("IServerInformation_Desc")]
[RootFacetAttribute(typeof(Server))]
public interface IServerInformation : IDmfFacet

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 collation information for the instance of SQL Server.
Public propertyCollationIDGets the CollationID for the instance of SQL Server.
Public propertyComparisonStyleGets the Comparision Style.for the instance of SQL Server.
Public propertyComputerNamePhysicalNetBIOSGets the host computer physical NetBIOS name.
Public propertyEditionGet 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 Boolean value that specifies case sensitivity.
Public propertyIsClusteredGets a Boolean value that specifies if the instance of SQL Server is clustered.
Public propertyIsFullTextInstalledGets a Boolean value that specifies if Full-Text is installed on the instance of SQL Server.
Public propertyIsSingleUserGets a Boolean value that specifies if the instance of SQL Server is read-only.
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 number of the resource database.
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 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.