Export (0) Print
Expand All

How to modify a stored procedure (Enterprise Manager)

SQL Server 2000

How to modify a stored procedure (Enterprise Manager)

To modify a stored procedure

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

  2. Expand Databases, expand the database in which the procedure belongs, and then click Stored Procedures.

  3. In the details pane, right-click the stored procedure, and then click Properties.

  4. In the Text box, change the text of the stored procedure as necessary. Press CTRL+TAB to indent the text of a SQL Server Enterprise Manager stored procedure.

  5. To check the syntax, click Check Syntax.

  6. To change the permissions, click Permissions.

See Also

Modifying and Renaming a Stored Procedure

© 2014 Microsoft