Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

StoredProcedure Properties

The StoredProcedure type exposes the following members.

  Name Description
Public property AnsiNullsStatus Gets the Boolean property value that specifies whether ISO NULL handling is enabled in the stored procedure.
Public property AssemblyName Gets or sets the name of the .NET assembly that is required by the referenced stored procedure.
Public property ClassName Gets or sets the name of the class called by the referenced stored procedure.
Public property CreateDate Gets the date and time when the stored procedure was created.
Public property DateLastModified Gets the date and time when the stored procedure was last modified.
Public property Events Gets the events associated with the stored procedure.
Public property ExecutionContext Gets or sets the execution context for the stored procedure.
Public property ExecutionContextPrincipal Gets or sets the execution context principal for the stored procedure.
Public property ExtendedProperties Gets the extended properties of the StoredProcedure object.
Public property ForReplication Gets or sets the Boolean property value that specifies whether the stored procedure is available for replication.
Public property ID Gets the ID value that uniquely identifies the stored procedure.
Public property ImplementationType Gets or sets the implementation type of the stored procedure.
Public property IsEncrypted Gets or sets the Boolean property value that specifies whether the stored procedure is encrypted.
Public property IsSchemaOwned Gets a Boolean property that specifies whether the stored procedure is owned by a schema.
Public property IsSystemObject Gets the Boolean property value that specifies whether the stored procedure is a system object.
Public property MethodName Gets the method name for the stored procedure.
Public property Name Gets or sets a String value that specifies the name of the stored procedure. (Overrides ScriptSchemaObjectBase.Name.)
Public property NumberedStoredProcedures Represents a collection of NumberedStoredProcedureCollection objects. Each NumberedStoredProcedure object represents a numbered stored procedure defined for the stored procedure.
Public property Owner Gets or sets the owner of the stored procedure.
Public property Parameters Represents a collection of StoredProcedureParameterCollection objects. Each StoredProcedureParameter object represents a parameter defined for the stored procedure.
Public property Parent Gets or sets the Database object that is the parent of the StoredProcedure object.
Public property Properties Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.)
Public property QuotedIdentifierStatus 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.
Public property Recompile Gets or sets the Boolean property value that specifies whether the stored procedure is recompiled before execution.
Public property Schema Gets or sets a String value that specifies the name of the schema that contains the stored procedure. (Overrides ScriptSchemaObjectBase.Schema.)
Public property Startup Gets or sets the Boolean property value that specifies whether the stored procedure runs when the instance of Microsoft SQL Server starts up.
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property TextBody Gets or sets the Transact-SQL string that defines the stored procedure.
Public property TextHeader Gets or sets the header part of the Transact-SQL string that defines the stored procedure.
Public property TextMode Gets or sets the Boolean property that specifies whether the text header is editable as text.
Public property Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.)
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)
Top
  Name Description
Explicit interface implemetation Private property ISfcSupportsDesignMode.IsDesignMode Gets a Boolean value that specifies whether the stored procedure supports design mode.
Top
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.