Export (0) Print
Expand All
5 out of 6 rated this helpful - Rate this topic

Viewing a Stored Procedure

SQL Server 2000

Several system stored procedures provide information from the system tables about stored procedures. Using these stored procedures, you can:

  • See the Transact-SQL statements used to create a stored procedure. This can be useful if you do not have the Transact-SQL script files used to create the stored procedure.

  • Get information about a stored procedure such as its owner, when it was created, and its parameters.

  • List the objects used by the specified stored procedure, and the procedures that use the specified stored procedure. This information can be used to identify the procedures affected by the changing or removal of an object in the database.

To view the definition of a stored procedure

Transact-SQL

Enterprise Manager

SQL-DMO

To view information about a stored procedure

Transact-SQL

Enterprise Manager

SQL-DMO

To view the dependencies of a stored procedure

Transact-SQL

Enterprise Manager

SQL-DMO

To view information about an extended stored procedure

Transact-SQL

Enterprise Manager

See Also

Querying Extended Stored Procedures Installed in SQL Server

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.