The Type property exposes configured attributes of the referenced Microsoft® SQL Server™ 2000 component.
object.Type [= value]
object
Expression that evaluates to an object in the Applies To list
value
Long integer that controls interpretation of SQL Server stored procedure text as described in Settings
Long, enumerated
Read/write
HRESULT GetType(SQLDMO_PROCEDURE_TYPE* pRetVal)
HRESULT SetType(SQLDMO_PROCEDURE_TYPE NewValue)
| 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.