SqlSmoObject Members

The SqlSmoObject object represents all Microsoft SQL Server objects.

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

Protected Constructors

  Name Description
SqlSmoObject Initializes a new instance of the SqlSmoObject class.

Top

Protected Fields

  Name Description
ms220353.protfield(en-US,SQL.90).gif m_ExtendedProperties  

Top

Public Properties

(see also Protected Properties )

  Name Description
ms220353.pubproperty(en-US,SQL.90).gif Properties Gets a collection of Property objects that represent the object properties.
ms220353.pubproperty(en-US,SQL.90).gif State  Gets the state of the referenced object. (inherited from SmoObjectBase)
ms220353.pubproperty(en-US,SQL.90).gif Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.
ms220353.pubproperty(en-US,SQL.90).gif UserData  Gets or sets user-defined data associated with the referenced object. (inherited from SmoObjectBase)

Top

Protected Properties

  Name Description
ms220353.protproperty(en-US,SQL.90).gif ExecuteForScalar Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option.
ms220353.protproperty(en-US,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.
ms220353.protproperty(en-US,SQL.90).gif PresetProperties Gets or sets the preset properties of the referenced object.
ms220353.protproperty(en-US,SQL.90).gif ScalarResult Gets the scalar result for the referenced object.

Top

Public Methods

(see also Protected Methods )

  Name Description
ms220353.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms220353.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms220353.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms220353.pubmethod(en-US,SQL.90).gif Initialize Overloaded. Initializes the object and forces the properties be loaded.
ms220353.pubmethod(en-US,SQL.90).gifms220353.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms220353.pubmethod(en-US,SQL.90).gif Refresh Refreshes the object and retrieves properties when the object is next accessed.
ms220353.pubmethod(en-US,SQL.90).gif ToString Overridden. Returns a String that represents the referenced object.

Top

Protected Methods

  Name Description
ms220353.protmethod(en-US,SQL.90).gif AlterImpl  
ms220353.protmethod(en-US,SQL.90).gif AlterImplFinish  
ms220353.protmethod(en-US,SQL.90).gif AlterImplInit  
ms220353.protmethod(en-US,SQL.90).gif AlterImplWorker  
ms220353.protmethod(en-US,SQL.90).gif BindDefaultImpl  
ms220353.protmethod(en-US,SQL.90).gif BindRuleImpl  
ms220353.protmethod(en-US,SQL.90).gif CheckCollation Validates the collation for the referenced object.
ms220353.protmethod(en-US,SQL.90).gif CheckObjectState Overloaded. Validates the state of the referenced object.
ms220353.protmethod(en-US,SQL.90).gif CheckObjectStateImpl  
ms220353.protmethod(en-US,SQL.90).gif CheckVersion80 Checks the validity of the object on Microsoft SQL Server 2000.
ms220353.protmethod(en-US,SQL.90).gif CheckVersion80SP3 Checks the validity of the object on Microsoft SQL Server 2000 SP3.
ms220353.protmethod(en-US,SQL.90).gif CheckVersion90 Check the validity of the object on Microsoft SQL Server 2005.
ms220353.protmethod(en-US,SQL.90).gif CheckVersionBelow90  
ms220353.protmethod(en-US,SQL.90).gif CleanObject  
ms220353.protmethod(en-US,SQL.90).gif CreateImpl  
ms220353.protmethod(en-US,SQL.90).gif CreateImplFinish  
ms220353.protmethod(en-US,SQL.90).gif CreateImplInit  
ms220353.protmethod(en-US,SQL.90).gif DropImpl  
ms220353.protmethod(en-US,SQL.90).gif DropImplWorker  
ms220353.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms220353.protmethod(en-US,SQL.90).gif FormatSqlVariant  
ms220353.protmethod(en-US,SQL.90).gif GenerateDataSpaceScript  
ms220353.protmethod(en-US,SQL.90).gif GetBindDefaultScript  
ms220353.protmethod(en-US,SQL.90).gif GetBindRuleScript  
ms220353.protmethod(en-US,SQL.90).gif GetBoolParameter Overloaded.  
ms220353.protmethod(en-US,SQL.90).gif GetDateTimeParameter  
ms220353.protmethod(en-US,SQL.90).gif GetDateTimeParameterAsInt  
ms220353.protmethod(en-US,SQL.90).gif GetDBName Gets the database name associated with the object.
ms220353.protmethod(en-US,SQL.90).gif GetEnumParameter  
ms220353.protmethod(en-US,SQL.90).gif GetFragOptionString  
ms220353.protmethod(en-US,SQL.90).gif GetGuidParameter  
ms220353.protmethod(en-US,SQL.90).gif GetParameter Overloaded.  
ms220353.protmethod(en-US,SQL.90).gif GetPropValue  
ms220353.protmethod(en-US,SQL.90).gif GetPropValueOptional  
ms220353.protmethod(en-US,SQL.90).gif GetPropValueOptionalAllowNull  
ms220353.protmethod(en-US,SQL.90).gif GetRealValue  
ms220353.protmethod(en-US,SQL.90).gif GetScriptingOptionsForCreate  
ms220353.protmethod(en-US,SQL.90).gif GetServerName Gets the name of the instance of Microsoft SQL Server with which the object is associated.
ms220353.protmethod(en-US,SQL.90).gif GetSqlServerVersionName Gets the version name of the instance of Microsoft SQL Server with which the object is associated.
ms220353.protmethod(en-US,SQL.90).gif GetStringParameter Overloaded.  
ms220353.protmethod(en-US,SQL.90).gif GetTimeSpanParameterAsInt  
ms220353.protmethod(en-US,SQL.90).gif GetUrnRecursive Overloaded.  
ms220353.protmethod(en-US,SQL.90).gif ImplInitialize  
ms220353.protmethod(en-US,SQL.90).gifms220353.static(en-US,SQL.90).gif IsCollectionDirty  
ms220353.protmethod(en-US,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.
ms220353.protmethod(en-US,SQL.90).gif IsObjectInitialized Verifies whether the object has been initialized.
ms220353.protmethod(en-US,SQL.90).gif IsObjectInSpace Verifies whether the object is isolated or connected to the instance of Microsoft SQL Server.
ms220353.protmethod(en-US,SQL.90).gif IsVersion80SP3  
ms220353.protmethod(en-US,SQL.90).gif MarkDropped  
ms220353.protmethod(en-US,SQL.90).gif MarkForDropImpl  
ms220353.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )
ms220353.protmethod(en-US,SQL.90).gif PostAlter  
ms220353.protmethod(en-US,SQL.90).gif PostCreate  
ms220353.protmethod(en-US,SQL.90).gif PostDrop  
ms220353.protmethod(en-US,SQL.90).gif ScriptAlter  
ms220353.protmethod(en-US,SQL.90).gif ScriptCreate  
ms220353.protmethod(en-US,SQL.90).gif ScriptDdl  
ms220353.protmethod(en-US,SQL.90).gif ScriptDrop  
ms220353.protmethod(en-US,SQL.90).gif ScriptImpl Overloaded.  
ms220353.protmethod(en-US,SQL.90).gif ScriptImplWorker  
ms220353.protmethod(en-US,SQL.90).gif SetParentImpl  
ms220353.protmethod(en-US,SQL.90).gifms220353.static(en-US,SQL.90).gif Trace Traces the object.
ms220353.protmethod(en-US,SQL.90).gif UnbindDefaultImpl  
ms220353.protmethod(en-US,SQL.90).gif UnbindRuleImpl  
ms220353.protmethod(en-US,SQL.90).gifms220353.static(en-US,SQL.90).gif UpdateCollectionState2  

Top

See Also

Reference

SqlSmoObject Class
Microsoft.SqlServer.Management.Smo Namespace