How to create a stored procedure (Enterprise Manager)

To create a stored procedure

1. Expand a server group; then expand a server.
2. Expand Databases; then expand the database in which to create the procedure.
3. Right-click Stored Procedures; then click New Stored Procedure....
4. Enter the text of the stored procedure. Press CTRL-TAB to indent the text of a stored procedure.
5. To check the syntax, click Check Syntax.
6. To set the permissions, click Permissions.

See Also

Creating a Stored Procedure