IServerInformation-Member

An interface based on the Information type properties.

Der IServerInformation-Typ macht die folgenden Member verfügbar.

Eigenschaften

	Name	Beschreibung
	BuildClrVersionString	Gets the CLR build version string for the instance of SQL Server.
	BuildNumber	Gets the build number for the instance of SQL Server.
	Collation	Gets collation information for the instance of SQL Server.
	CollationID	Gets the CollationID for the instance of SQL Server.
	ComparisonStyle	Gets the Comparision Style.for the instance of SQL Server.
	ComputerNamePhysicalNetBIOS	Gets the host computer physical NetBIOS name.
	Edition	Get the edition of the instance of SQL Server.
	EngineEdition	Gets the SQL Server Engine edition as an edition object.
	ErrorLogPath	Gets the error log path for the instance of SQL Server.
	IsCaseSensitive	Gets a Boolean value that specifies case sensitivity.
	IsClustered	Gets a Boolean value that specifies if the instance of SQL Server is clustered.
	IsFullTextInstalled	Gets a Boolean value that specifies if Full-Text is installed on the instance of SQL Server.
	IsSingleUser	Gets a Boolean value that specifies if the instance of SQL Server is read-only.
	Language	Gets the SQL Server language.
	MasterDBLogPath	Gets the master database log path for the instance of SQL Server.
	MasterDBPath	Gets the master database data path for the instance of SQL Server.
	MaxPrecision	Gets the greatest decimal precision available for exact numeric data types (not floating point), including decimal and numeric.
	NetName	Gets the network name for an instance of SQL Server.
	OSVersion	Gets the host computer operating system version.
	PhysicalMemory	Gets the total RAM installed, in MB, for the computer that is running the instance of SQL Server.
	Platform	Gets the hardware platform for the computer that is running the instance of SQL Server.
	Processors	Gets the number of processors that are installed on the computer that is running the instance of SQL Server.
	Product	Gets the product title for the instance of SQL Server.
	ProductLevel	Gets the product level for the instance of SQL Server.
	ResourceLastUpdateDateTime	Gets a DateTime object that specifies the last time the resource database was updated.
	ResourceVersionString	Gets the version number of the resource database.
	RootDirectory	Gets the root directory for the instance of SQL Server.
	SqlCharSet	Gets the SQL character set ID from the collation ID as a tinyint.
	SqlCharSetName	Gets the SQL character set name from the collation.
	SqlSortOrder	Gets the SQL sort order ID from the collation.
	SqlSortOrderName	Gets SQL sort order name from the collation.
	VersionMajor	Gets the portion of a component version identifier to the left of the first decimal point in the identifier.
	VersionMinor	Gets the portion of a component version identifier to the right of the first decimal point in the identifier.
	VersionString	Gets the date, version, and processor type of the instance of SQL Server.

Zum Anfang

Siehe auch

Verweis

IServerInformation Schnittstelle

Microsoft.SqlServer.Management.Smo-Namespace