Viewing List of Parameters SP

sidneyfuerte · September 12th, 2003, 01:20 PM

Hi everyone,

I'm using SQL Server 2000, is there a way to view the list of paramaters of a Stored Procedure using Query Analyzer? sp_helptext is one of course but this will not do co'z the SP is encrypted. Is there any other way to do this?

Thanks/Regards
Sidney

Jeff Mason · September 12th, 2003, 02:17 PM

Sure.

Make sure the object browser is displayed (Tools -> Object browser -> Show/Hide). Click on the database, then stored procedures, then click on the stored procedure you want to display. One of the displayed nodes is 'Parameters'. Click on that to display the parameters, their name, datatype, and direction.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com