Information 类
The Information class contains nonconfigurable information about the instance of SQL Server. These include system information and options that are set during Setup, such as the collation.
继承层次结构
System. . :: . .Object
Microsoft.SqlServer.Management.Smo. . :: . .SmoObjectBase
Microsoft.SqlServer.Management.Smo. . :: . .SqlSmoObject
Microsoft.SqlServer.Management.Smo..::..Information
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
Public NotInheritable Class Information _
Inherits SqlSmoObject
用法
Dim instance As Information
public sealed class Information : SqlSmoObject
public ref class Information sealed : public SqlSmoObject
[<SealedAttribute>]
type Information =
class
inherit SqlSmoObject
end
public final class Information extends SqlSmoObject
Information 类型公开以下成员。
属性
名称 | 说明 | |
---|---|---|
BuildClrVersion | Gets a version object that identifies the common language runtime that is running in the server. | |
BuildClrVersionString | A string that identifies the build number of the common language runtime that is running in the server. | |
BuildNumber | Gets the build number for the instance of SQL Server. | |
Collation | Gets the default collation for the instance of SQL Server. | |
CollationID | Gets the collation ID for the instance of SQL Server. | |
ComparisonStyle | Gets the comparison style for the instance of SQL Server. | |
ComputerNamePhysicalNetBIOS | Gets the computer name stored in the net BIOS. | |
Edition | Gets the edition of the instance of SQL Server. | |
EngineEdition | Gets the edition of the engine for the instance of SQL Server. | |
ErrorLogPath | Gets the file directory where the error log is stored on the instance of SQL Server. | |
ExecuteForScalar | 获取或设置 Boolean 属性值,该值指定对象是否设置为针对标量选项执行。 (从 SqlSmoObject 继承。) | |
IsCaseSensitive | Gets the Boolean value that specifies whether the instance of SQL Server is case-sensitive. | |
IsClustered | Gets the Boolean value that specifies whether the instance of SQL Server is a clustered server. | |
IsFullTextInstalled | Gets the Boolean value that specifies whether full-text service is installed on the instance of SQL Server. | |
IsSingleUser | Gets the Boolean value that specifies whether the instance of SQL Server is read-only. | |
IsTouched | 获取 Boolean 属性值,该值指定在服务器上对象属性是否已更新但尚未持久化。 (从 SqlSmoObject 继承。) | |
Language | Gets the default language used by the instance of SQL Server. | |
MasterDBLogPath | Gets the log file directory for the master database on the instance of SQL Server. | |
MasterDBPath | Gets the database file directory for the master database on 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 NetBIOS name of the network on which the instance of SQL Server is running. | |
ObjectInSpace | 获取 Boolean 属性值,该值指定对象是否单独存在,或者对象是否直接或间接连接到 SQL Server 的实例。 (从 SqlSmoObject 继承。) | |
OSVersion | Gets the operating system version of the computer running the instance of SQL Server. | |
Parent | Gets the Server object that is the parent object of the Information object. | |
PhysicalMemory | Gets the total RAM installed, in MB, for the computer running the instance of SQL Server. | |
Platform | Gets the hardware platform for the computer running the instance of SQL Server. | |
Processors | Gets the number of processors installed on the computer 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. | |
Properties | 获取表示对象属性的 Property 对象的集合。 (从 SqlSmoObject 继承。) | |
ResourceLastUpdateDateTime | Gets the date and time when the SQL Server resource was last updated. | |
ResourceVersion | Gets the version of the SQL Server resource. | |
ResourceVersionString | Gets the version of the SQL Server resource in string format. | |
RootDirectory | Gets the root directory for the instance of SQL Server. | |
ScalarResult | 获取所引用对象的标量结果。 (从 SqlSmoObject 继承。) | |
SqlCharSet | Gets the Int16 value that identifies the character set used by the instance of SQL Server. | |
SqlCharSetName | Gets the name of the character set used by the instance of SQL Server. | |
SqlSortOrder | Gets the Int16 value that identifies the sort order used by the instance of SQL Server. | |
SqlSortOrderName | Gets the name of the sort order used by the instance of SQL Server. | |
State | Gets the state of the referenced object. (从 SmoObjectBase 继承。) | |
Urn | 获取唯一标识对象的统一资源名称 (URN) 地址值。 (从 SqlSmoObject 继承。) | |
UserData | Gets or sets user-defined data associated with the referenced object. (从 SmoObjectBase 继承。) | |
Version | Gets the version of the instance of SQL Server. | |
VersionMajor | Gets the major version number of the instance of SQL Server. | |
VersionMinor | Gets the minor version of the instance of SQL Server. | |
VersionString | Gets the date, version, and processor type of the instance of SQL Server. |
页首
方法
页首
事件
名称 | 说明 | |
---|---|---|
PropertyChanged | 表示更改属性时发生的事件。 (从 SqlSmoObject 继承。) | |
PropertyMetadataChanged | 表示属性元数据更改时发生的事件。 (从 SqlSmoObject 继承。) |
页首
字段
名称 | 说明 | |
---|---|---|
m_ExtendedProperties | 表示一个属性,可以对该属性进行定义以便扩展 SqlSmoObject 提供的属性。 (从 SqlSmoObject 继承。) | |
singletonParent | 表示单一父级。 (从 SqlSmoObject 继承。) |
页首
显式接口实现
名称 | 说明 | |
---|---|---|
IAlienObject. . :: . .Discover | 发现任何依赖关系。不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SqlSmoObject 继承。) | |
IAlienObject. . :: . .GetDomainRoot | 返回域的根。 (从 SqlSmoObject 继承。) | |
IAlienObject. . :: . .GetParent | 获取此对象的父对象。不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SqlSmoObject 继承。) | |
IAlienObject. . :: . .GetPropertyType | 获取指定属性的类型。 (从 SqlSmoObject 继承。) | |
IAlienObject. . :: . .GetPropertyValue | 获取指定属性的值。 (从 SqlSmoObject 继承。) | |
IAlienObject. . :: . .GetUrn | 获取对象的统一资源名称。不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SqlSmoObject 继承。) | |
IAlienObject. . :: . .Resolve | 获取一个实例,该实例包含与来自该对象的统一资源名称的对象有关的信息。 (从 SqlSmoObject 继承。) | |
IAlienObject. . :: . .SetObjectState | 将对象状态设置为指定的 SfcObjectState 值。 (从 SqlSmoObject 继承。) | |
IAlienObject. . :: . .SetPropertyValue | 设置属性值。 (从 SqlSmoObject 继承。) | |
ISfcPropertyProvider. . :: . .GetPropertySet | 获取对此对象的属性集的接口引用。不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SqlSmoObject 继承。) |
页首
注释
后续版本的 Microsoft SQL Server 将删除该功能。请避免在新的开发工作中使用该功能,并着手修改当前还在使用该功能的应用程序。
To get Information object properties, users can be a member of the public fixed server role.
To set Information object properties, users must be a member of the sysadmin fixed server role.
Thread Safety
此类型的任何公共静态(Microsoft Visual Basic 中的 Shared)成员在多线程操作中是安全的。不保证所有实例成员都是线程安全的。
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。