StoredProcedure Properties

 

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubpropertyAnsiNullsStatus

Gets the Boolean property value that specifies whether ISO NULL handling is enabled in the stored procedure.

System_CAPS_pubpropertyAssemblyName

Gets or sets the name of the .NET assembly that is required by the referenced stored procedure.

System_CAPS_pubpropertyClassName

Gets or sets the name of the class called by the referenced stored procedure.

System_CAPS_pubpropertyCreateDate

Gets the date and time when the stored procedure was created.

System_CAPS_pubpropertyDateLastModified

Gets the date and time when the stored procedure was last modified.

System_CAPS_pubpropertyEvents

Gets the events associated with the stored procedure.

System_CAPS_pubpropertyExecutionContext

Gets or sets the execution context for the stored procedure.

System_CAPS_pubpropertyExecutionContextPrincipal

Gets or sets the execution context principal for the stored procedure.

System_CAPS_pubpropertyExecutionManager

(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyExtendedProperties

Gets the extended properties of the StoredProcedure object.

System_CAPS_pubpropertyForReplication

Gets or sets the Boolean property value that specifies whether the stored procedure is available for replication.

System_CAPS_pubpropertyID

Gets the ID value that uniquely identifies the stored procedure.

System_CAPS_pubpropertyImplementationType

Gets or sets the implementation type of the stored procedure.

System_CAPS_pubpropertyIsEncrypted

Gets or sets the Boolean property value that specifies whether the stored procedure is encrypted.

System_CAPS_pubpropertyIsNativelyCompiled

Gets or sets the Boolean property that specifies whether the stored procedure is natively compiled.

System_CAPS_pubpropertyIsSchemaBound

Gets or sets the Boolean property that specifies whether the stored procedure is bound to the schema of the database objects it references.

System_CAPS_pubpropertyIsSchemaOwned

Gets a Boolean property that specifies whether the stored procedure is owned by a schema.

System_CAPS_pubpropertyIsSystemObject

Gets the Boolean property value that specifies whether the stored procedure is a system object.

System_CAPS_pubpropertyMethodName

Gets the method name for the stored procedure.

System_CAPS_pubpropertyName

Gets or sets a String value that specifies the name of the stored procedure.(Overrides ScriptSchemaObjectBase.Name.)

System_CAPS_pubpropertyNumberedStoredProcedures

Represents a collection of NumberedStoredProcedureCollection objects. Each NumberedStoredProcedure object represents a numbered stored procedure defined for the stored procedure.

System_CAPS_pubpropertyOwner

Gets or sets the owner of the stored procedure.

System_CAPS_pubpropertyParameters

Represents a collection of StoredProcedureParameterCollection objects. Each StoredProcedureParameter object represents a parameter defined for the stored procedure.

System_CAPS_pubpropertyParent

Gets or sets the Database object that is the parent of the StoredProcedure object.

System_CAPS_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyQuotedIdentifierStatus

Gets or sets a Boolean property value that specifies whether identifiers delimited by double quotation marks are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules.

System_CAPS_pubpropertyRecompile

Gets or sets the Boolean property value that specifies whether the stored procedure is recompiled before execution.

System_CAPS_pubpropertySchema

Gets or sets a String value that specifies the name of the schema that contains the stored procedure.(Overrides ScriptSchemaObjectBase.Schema.)

System_CAPS_pubpropertyStartup

Gets or sets the Boolean property value that specifies whether the stored procedure runs when the instance of Microsoft SQL Server starts up.

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyTextBody

Gets or sets the Transact-SQL string that defines the stored procedure.

System_CAPS_pubpropertyTextHeader

Gets or sets the header part of the Transact-SQL string that defines the stored procedure.

System_CAPS_pubpropertyTextMode

Gets or sets the Boolean property that specifies whether the text header is editable as text.

System_CAPS_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

Return to top
Show: