Export (0) Print
Expand All

Information Properties

The Information type exposes the following members.

  Name Description
Public property BuildClrVersion Gets a version object that identifies the common language runtime that is running in the server.
Public property BuildClrVersionString A string that identifies the build number of the common language runtime that is running in the server.
Public property BuildNumber Gets the build number for the instance of SQL Server.
Public property Collation Gets the default collation for the instance of SQL Server.
Public property CollationID Gets the collation ID for the instance of SQL Server.
Public property ComparisonStyle Gets the comparison style for the instance of SQL Server.
Public property ComputerNamePhysicalNetBIOS Gets the computer name stored in the net BIOS.
Public property Edition Gets the edition of the instance of SQL Server.
Public property EngineEdition Gets the edition of the engine for the instance of SQL Server.
Public property ErrorLogPath Gets the file directory where the error log is stored on the instance of SQL Server.
Public property FullyQualifiedNetName Gets the fully qualified NetBIOS name of the network on which the instance of SQL Server is running.
Public property IsCaseSensitive Gets the Boolean value that specifies whether the instance of SQL Server is case-sensitive.
Public property IsClustered Gets the Boolean value that specifies whether the instance of SQL Server is a clustered server.
Public property IsFullTextInstalled Gets the Boolean value that specifies whether full-text service is installed on the instance of SQL Server.
Public property IsHadrEnabled Gets a value that indicates whether the HADR is enabled.
Public property IsSingleUser Gets the Boolean value that specifies whether the instance of SQL Server is read-only.
Public property IsXTPSupported Gets the Boolean value that specifies whether the instance of SQL Server supports Extreme Transaction Processing (XTP).
Public property Language Gets the default language used by the instance of SQL Server.
Public property MasterDBLogPath Gets the log file directory for the master database on the instance of SQL Server.
Public property MasterDBPath Gets the database file directory for the master database on the instance of SQL Server.
Public property MaxPrecision Gets the greatest decimal precision available for exact numeric data types (not floating point), including decimal and numeric.
Public property NetName Gets the NetBIOS name of the network on which the instance of SQL Server is running.
Public property OSVersion Gets the operating system version of the computer running the instance of SQL Server.
Public property Parent Gets the Server object that is the parent object of the Information object.
Public property PhysicalMemory Gets the total RAM installed, in MB, for the computer running the instance of SQL Server.
Public property Platform Gets the hardware platform for the computer running the instance of SQL Server.
Public property Processors Gets the number of processors installed on the computer running the instance of SQL Server.
Public property Product Gets the product title for the instance of SQL Server.
Public property ProductLevel Gets the product level for the instance of SQL Server.
Public property Properties Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.)
Public property ResourceLastUpdateDateTime Gets the date and time when the SQL Server resource was last updated.
Public property ResourceVersion Gets the version of the SQL Server resource.
Public property ResourceVersionString Gets the version of the SQL Server resource in string format.
Public property RootDirectory Gets the root directory for the instance of SQL Server.
Public property SqlCharSet Gets the Int16 value that identifies the character set used by the instance of SQL Server.
Public property SqlCharSetName Gets the name of the character set used by the instance of SQL Server.
Public property SqlSortOrder Gets the Int16 value that identifies the sort order used by the instance of SQL Server.
Public property SqlSortOrderName Gets the name of the sort order used by the instance of SQL Server.
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.)
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)
Public property Version Gets the version of the instance of SQL Server.
Public property VersionMajor Gets the major version number of the instance of SQL Server.
Public property VersionMinor Gets the minor version of the instance of SQL Server.
Public property VersionString Gets the date, version, and processor type of the instance of SQL Server.
Top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft