See Also

StoredProcedure Class  | RedGate.SQLCompare.Engine Namespace

See Also RedGate.SQLCompare.Engine Send comments on this topic.

StoredProcedure Class Members

RedGate.SQLCompare.Engine Namespace : StoredProcedure Class

StoredProcedure overview

Public Properties

Public Property AnsiNullsOn True if the stored procedure was created with ansi nulls on.
Public Property Assembly The CLR assembly for the stored procedure, if it is a CLR stored procedure.
Public Property AssemblyClass The CLR assembly class name for the stored procedure, if it is a CLR stored procedure.
Public Property AssemblyMethod The CLR assembly method name for the stored procedure, if it is a CLR stored procedure.
Public Property CLRObject True if the stored procedure is a CLR stored procedure.
Public Property Database (Inherited from SchemaObject)The database to which the object belongs.
Public Property Encrypted True if the stored procedure definition is encrypted.
Public Property ExecuteAs The user whose security context is to be used for the execution of the stored procedure. This is a SQL Server 2005 feature.
Public Property ExtendedProperties The extended properties defined for the stored procedure.
Public Property FullyQualifiedName (Inherited from SchemaObject)The fully-qualified name of the object.
Public Property Name (Inherited from SchemaObject) The name of the object.
Public Property ObjectType Overridden. Returns ObjectType.StoredProcedure
Public Property Owner (Inherited from SchemaObject) The owner or the schema of the object.
Public Property Parameters The parameters of the stored procedure.
Public Property Permissions (Inherited from SchemaObject)The permissions on the object.
Public Property QuotedIdentifierOn True if the stored procedure was created with quoted identifiers on.
Public Property ScriptSource (Inherited from SchemaObject) The location of the creation script for this object if the database source is set to scripts folder.
Public Property ScriptSourceAuthorization (Inherited from SchemaObject) The location of the creation script for the ALTER AUTHORIZATION statement for this object if the database source is set to scripts folder.
Public Property Text The text of the stored procedure.

Public Methods

Public Method Equals Overloaded. Overridden. Compares the stored procedure with a specified stored procedure.
Public Method ScriptObject Overridden.  Scripts the object.
Public Method ToString (Inherited from SchemaObject) Returns the fully-qualified name of the object prefixed with the object type.

See Also

StoredProcedure Class  | RedGate.SQLCompare.Engine Namespace

 

 


© 2003 - 2007 Red Gate Software Ltd. All Rights Reserved.