The Type property exposes configured attributes of the referenced Microsoft® SQL Server™ component.
object.Type [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Long integer controlling interpretation of SQL Server stored procedure text as described in Settings |
| Constant | Value | Description |
|---|---|---|
| SQLDMOProc_Extended | 2 | StoredProcedure object references an extended stored procedure. |
| SQLDMOProc_Macro | 3 | Reserved for future use. |
| SQLDMOProc_ReplicationFilter | 4 | Reserved for future use. |
| SQLDMOProc_Standard | 1 | Default. StoredProcedure object references a SQL Server stored procedure. |
| SQLDMOProc_Unknown | 0 | Bad or invalid value. |
When using the StoredProcedure object to create a SQL Server stored procedure, setting the Name, Type, and Text properties define the stored procedure. By default, the text of a stored procedure is interpreted as a Transact-SQL script. When the stored procedure is an entry point for an extended stored procedure, the text of the procedure specifies an executable-image library by name.
Long, enumerated
Read/write
HRESULT GetType(SQLDMO_PROCEDURE_TYPE* pRetVal)
HRESULT SetType(SQLDMO_PROCEDURE_TYPE NewValue)