Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Stored Procedure Properties (General Page)

Displays information about a stored procedure. All information is read-only.

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.

Community Additions

ADD
Show:
© 2015 Microsoft