Information Members

The Information class contains nonconfigurable information about the instance of Microsoft SQL Server. These include system information and options that are set during setup, such as the collation.

The following tables list the members exposed by the Information type.

Protected Fields

  名称 Description
ms219627.protfield(zh-cn,SQL.90).gif m_ExtendedProperties  (inherited from SqlSmoObject )

顶部

Public Properties

(see also Protected Properties )

  名称 Description
ms219627.pubproperty(zh-cn,SQL.90).gif Collation Gets the default collation for the instance of Microsoft SQL Server.
ms219627.pubproperty(zh-cn,SQL.90).gif Edition Gets the edition of the instance of Microsoft SQL Server.
ms219627.pubproperty(zh-cn,SQL.90).gif ErrorLogPath Gets the file directory where the error log is stored on the instance of Microsoft SQL Server.
ms219627.pubproperty(zh-cn,SQL.90).gif IsCaseSensitive Gets the Boolean value that specifies whether the instance of Microsoft SQL Server is case sensitive.
ms219627.pubproperty(zh-cn,SQL.90).gif IsClustered Gets the Boolean value that specifies whether the instance of Microsoft SQL Server is a clustered server.
ms219627.pubproperty(zh-cn,SQL.90).gif IsFullTextInstalled Gets the Boolean value that specifies whether Full-Text Search is installed on the instance of Microsoft SQL Server.
ms219627.pubproperty(zh-cn,SQL.90).gif IsSingleUser Gets the Boolean value that specifies whether the instance of Microsoft SQL Server is read-only.
ms219627.pubproperty(zh-cn,SQL.90).gif Language Gets the default language used by the instance of Microsoft SQL Server.
ms219627.pubproperty(zh-cn,SQL.90).gif MasterDBLogPath Gets the log file directory for the master database on the instance of Microsoft SQL Server.
ms219627.pubproperty(zh-cn,SQL.90).gif MasterDBPath Gets the database file directory for the master database on the instance of Microsoft SQL Server.
ms219627.pubproperty(zh-cn,SQL.90).gif MaxPrecision Gets the greatest decimal precision available for exact numeric data types (not floating point), including decimal and numeric.
ms219627.pubproperty(zh-cn,SQL.90).gif NetName Gets the NetBIOS name of the network on which the instance of Microsoft SQL Server is running.
ms219627.pubproperty(zh-cn,SQL.90).gif OSVersion Gets the operating system version of the computer running the instance of Microsoft SQL Server.
ms219627.pubproperty(zh-cn,SQL.90).gif Parent Gets the Server object that is the parent object of the Information object.
ms219627.pubproperty(zh-cn,SQL.90).gif PhysicalMemory Gets the total RAM installed, in megabytes, for the computer running the instance of Microsoft SQL Server.
ms219627.pubproperty(zh-cn,SQL.90).gif Platform Gets the hardware platform for the computer running the instance of Microsoft SQL Server.
ms219627.pubproperty(zh-cn,SQL.90).gif Processors Gets the number of processors installed on the computer running the instance of Microsoft SQL Server.
ms219627.pubproperty(zh-cn,SQL.90).gif Product Gets the product title for the instance of Microsoft SQL Server.
ms219627.pubproperty(zh-cn,SQL.90).gif ProductLevel Gets the product level for the instance of Microsoft SQL Server.
ms219627.pubproperty(zh-cn,SQL.90).gif Properties  Gets a collection of Property objects that represent the object properties. (inherited from SqlSmoObject)
ms219627.pubproperty(zh-cn,SQL.90).gif RootDirectory Gets the root directory for the instance of Microsoft SQL Server.
ms219627.pubproperty(zh-cn,SQL.90).gif State  Gets the state of the referenced object. (inherited from SmoObjectBase)
ms219627.pubproperty(zh-cn,SQL.90).gif Urn  Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (inherited from SqlSmoObject)
ms219627.pubproperty(zh-cn,SQL.90).gif UserData  Gets or sets user-defined data associated with the referenced object. (inherited from SmoObjectBase)
ms219627.pubproperty(zh-cn,SQL.90).gif Version Gets the version of the instance of Microsoft SQL Server.
ms219627.pubproperty(zh-cn,SQL.90).gif VersionString Gets the date, version, and processor type of the instance of Microsoft SQL Server.

顶部

Protected Properties

  名称 Description
ms219627.protproperty(zh-cn,SQL.90).gif ExecuteForScalar  Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (inherited from SqlSmoObject)
ms219627.protproperty(zh-cn,SQL.90).gif ObjectInSpace  Gets the Boolean property value that specifies whether the object exists in isolation or whether it is connected to the instance of Microsoft SQL Server directly or indirectly. (inherited from SqlSmoObject)
ms219627.protproperty(zh-cn,SQL.90).gif PresetProperties  Gets or sets the preset properties of the referenced object. (inherited from SqlSmoObject)
ms219627.protproperty(zh-cn,SQL.90).gif ScalarResult  Gets the scalar result for the referenced object. (inherited from SqlSmoObject)

顶部

Public Methods

(see also Protected Methods )

  名称 Description
ms219627.pubmethod(zh-cn,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms219627.pubmethod(zh-cn,SQL.90).gif GetHashCode  (inherited from Object )
ms219627.pubmethod(zh-cn,SQL.90).gif GetType  (inherited from Object )
ms219627.pubmethod(zh-cn,SQL.90).gif Initialize  Overloaded. Initializes the object and forces the properties be loaded. (inherited from SqlSmoObject)
ms219627.pubmethod(zh-cn,SQL.90).gifms219627.static(zh-cn,SQL.90).gif ReferenceEquals  (inherited from Object )
ms219627.pubmethod(zh-cn,SQL.90).gif Refresh  Refreshes the object and retrieves properties when the object is next accessed. (inherited from SqlSmoObject)
ms219627.pubmethod(zh-cn,SQL.90).gif ToString  Returns a String that represents the referenced object. (inherited from SqlSmoObject)

顶部

Protected Methods

  名称 Description
ms219627.protmethod(zh-cn,SQL.90).gif AlterImpl  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif AlterImplFinish  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif AlterImplInit  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif AlterImplWorker  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif BindDefaultImpl  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif BindRuleImpl  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif CheckCollation  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif CheckObjectState  Overloaded. Validates the state of the referenced object. (inherited from SqlSmoObject)
ms219627.protmethod(zh-cn,SQL.90).gif CheckObjectStateImpl  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif CheckVersion80  Checks the validity of the object on Microsoft SQL Server 2000. (inherited from SqlSmoObject)
ms219627.protmethod(zh-cn,SQL.90).gif CheckVersion80SP3  Checks the validity of the object on Microsoft SQL Server 2000 SP3. (inherited from SqlSmoObject)
ms219627.protmethod(zh-cn,SQL.90).gif CheckVersion90  Check the validity of the object on Microsoft SQL Server 2005. (inherited from SqlSmoObject)
ms219627.protmethod(zh-cn,SQL.90).gif CheckVersionBelow90  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif CleanObject  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif CreateImpl  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif CreateImplFinish  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif CreateImplInit  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif DropImpl  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif DropImplWorker  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif Finalize  (inherited from Object )
ms219627.protmethod(zh-cn,SQL.90).gif FormatSqlVariant  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GenerateDataSpaceScript  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GetBindDefaultScript  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GetBindRuleScript  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GetBoolParameter  Overloaded. (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GetDateTimeParameter  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GetDateTimeParameterAsInt  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GetDBName  Gets the database name associated with the object. (inherited from SqlSmoObject)
ms219627.protmethod(zh-cn,SQL.90).gif GetEnumParameter  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GetFragOptionString  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GetGuidParameter  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GetParameter  Overloaded. (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GetPropValue  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GetPropValueOptional  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GetPropValueOptionalAllowNull  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GetRealValue  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GetScriptingOptionsForCreate  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GetServerName  Gets the name of the instance of Microsoft SQL Server with which the object is associated. (inherited from SqlSmoObject)
ms219627.protmethod(zh-cn,SQL.90).gif GetSqlServerVersionName  Gets the version name of the instance of Microsoft SQL Server with which the object is associated. (inherited from SqlSmoObject)
ms219627.protmethod(zh-cn,SQL.90).gif GetStringParameter  Overloaded. (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GetTimeSpanParameterAsInt  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif GetUrnRecursive  Overloaded. (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif ImplInitialize  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gifms219627.static(zh-cn,SQL.90).gif IsCollectionDirty  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif IsObjectDirty  Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of Microsoft SQL Server. (inherited from SqlSmoObject)
ms219627.protmethod(zh-cn,SQL.90).gif IsObjectInitialized  Verifies whether the object has been initialized. (inherited from SqlSmoObject)
ms219627.protmethod(zh-cn,SQL.90).gif IsObjectInSpace  Verifies whether the object is isolated or connected to the instance of Microsoft SQL Server. (inherited from SqlSmoObject)
ms219627.protmethod(zh-cn,SQL.90).gif IsVersion80SP3  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif MarkDropped  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif MarkForDropImpl  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif MemberwiseClone  (inherited from Object )
ms219627.protmethod(zh-cn,SQL.90).gif PostAlter  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif PostCreate  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif PostDrop  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif ScriptAlter  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif ScriptCreate  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif ScriptDdl  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif ScriptDrop  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif ScriptImpl  Overloaded. (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif ScriptImplWorker  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif SetParentImpl  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gifms219627.static(zh-cn,SQL.90).gif Trace  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif UnbindDefaultImpl  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gif UnbindRuleImpl  (inherited from SqlSmoObject )
ms219627.protmethod(zh-cn,SQL.90).gifms219627.static(zh-cn,SQL.90).gif UpdateCollectionState2  (inherited from SqlSmoObject )

顶部

请参阅

参考

Information Class
Microsoft.SqlServer.Management.Smo Namespace

其他资源

Configuring SQL Server in SMO