StoredProcedure Object Properties Method Lists Collections
| Property | Description |
|---|
| Application Application Write: No |
The Application object. |
| CreateDate String Write: No |
The date and time the stored procedure was created. |
| ID Long Write: No |
The object ID of the stored procedure. |
| Name Identifier Write: Yes |
The name of the stored procedure. |
| Owner Identifier Write: No |
The user who created the stored procedure. |
| Parent Database Write: No |
The Database object. |
| Startup Boolean Write: Before Add |
Determines if this stored procedure is executed automatically when SQL Server starts. If True, this stored procedure is executed automatically when SQL Server starts. If False, it is not executed automatically. |
| SystemObject Boolean Write: No |
Indicates if this is a SQL Server system stored procedure. If True, this is a SQL Server system stored procedure. If False, this stored procedure was created by a user. |
| Text String Write: Before Add |
The original Transact-SQL statement used to create the standard stored procedure, or the full path and file name of the extended stored procedure DLL. |
| Type SQLOLE_PROCEDURE_TYPE Write: No |
The type of stored procedure. |
| TypeOf SQLOLE_OBJECT_TYPE Write: No |
The type of object. |
| UserData Long Write: Yes |
Temporary storage space contained in this object for private use by the application. SQL-DMO does not use this property. |