Stored Procedure Properties (General Page)
Displays information about a stored procedure. All information is read-only.
Options
- Database
The name of the database containing this stored procedure.
- Server
The name of the current server instance.
- User
The name of the user of this connection.
- Created date
Displays the date the stored procedure was created.
- Name
The name of the current stored procedure.
- Schema
Displays the schema that owns the stored procedure.
- System object
Indicates whether the stored procedure is a system object. Values are True and False.
- ANSI NULLs
Indicates if the object was created with the ANSI NULLs option.
- Encrypted
Indicates whether the stored procedure is encrypted. Values are True and False.
- For replication
Indicates if the object was created with the FOR REPLICATION option.
- Quoted identifier
Indicates if the object was created with the quoted identifier option.
- Recompile
Indicates if the object was created with the RECOMPILE option.
See Also
Other Resources
Stored Procedures (Database Engine)
CREATE PROCEDURE (Transact-SQL)
ALTER PROCEDURE (Transact-SQL)