Stored Procedure Properties

Use this form to create or edit stored procedures within a database.

Access this form by selecting the Stored Procedures node (within a database) in the navigation pane and clicking the design icon (to edit an existing item) or the new stored procedure icon (to add a new item).

Database Objects
Provides a list of database tables, columns, views etc which you can drag and drop into the text area.

Keywords
Provides a list of common SQL commands which you can drag and drop into the text area.

Name
View the name of the stored procedure.

Owner
View the owner of the stored procedure.

Use quoted identifiers
Specify if the stored procedure should allow quoted identifiers.

Text
View the syntax of the stored procedure.

Check Syntax
Check the syntax of the Transact-SQL script used to create the stored procedure.