How to create a stored procedure (Enterprise Manager)

  New Information - SQL Server 2000 SP3.

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.

   Security Note  Validate all user input. Do not concatenate user input before validating it. Never execute a command constructed from unvalidated user input. For more information, see Validating User Input.

See Also