Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 12th, 2003, 01:20 PM
Authorized User
 
Join Date: Jun 2003
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to sidneyfuerte Send a message via AIM to sidneyfuerte Send a message via MSN to sidneyfuerte Send a message via Yahoo to sidneyfuerte
Default Viewing List of Parameters SP

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
__________________
Thanks/Regards
Sidney
 
Old September 12th, 2003, 02:17 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Passing Parameters to Subreports containing SP ms1234 Crystal Reports 0 May 18th, 2007 11:46 AM
Execute DTS with input parameters from a SP dbradley SQL Server 2000 6 March 22nd, 2006 05:36 AM
Access List Box & stored procedure with parameters nrathod_97 Access VBA 5 September 24th, 2004 08:25 AM
optional parameters in SP yuqlin BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 7 July 13th, 2004 03:28 PM
Can a SP run another SP as sa? dbradley SQL Server 2000 0 July 17th, 2003 08:35 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.