How to create a stored procedure (Enterprise Manager)

How to Install SQL Server 2000

How To

How to create a stored procedure (Enterprise Manager)

To create a stored procedure

  1. Expand a server group, and then expand a server.

  2. Expand Databases, and then expand the database in which to create the procedure.

  3. Right-click Stored Procedures, and then click New Stored Procedure.

  4. Enter the text of the stored procedure. Press TAB to indent the text of a stored procedure. Press CTRL+TAB to exit the text box, or click an appropriate button.

  5. To check the syntax, click Check Syntax.

  6. To set the permissions, click Permissions.

See Also

Creating a Stored Procedure