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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft