Opening a Stored Procedure

See Also

You can open a stored procedure in your database to view or edit its text. You can create a stored procedure using Microsoft® Visual Database Tools™, or using tools in the database itself.

To open a stored procedure

1. In Data View, expand the Stored Procedures folder.
   
   
2. Double-click the name of the stored procedure you want to open.

   -or-

   Right-click the name of the stored procedure that you want to open, choose Open from the shortcut menu.

The stored procedure is opened in a text editor that you can use to edit the SQL statements. For details about editing stored procedures, see your database documentation. For Microsoft SQL Server databases, see "Creating Stored Procedures" in SQL Server Books Online.

Note   You can place SQL Server stored procedures under source control using Microsoft^® Visual SourceSafe™. For more information, see the Visual SourceSafe documentation.