Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Unanswered: 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

  2. #2
    Join Date
    Sep 2003
    Posts
    60

    Re: Viewing List of Parameters SP

    Originally posted by sidneyfuerte
    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
    sp_sproc_columns
    Last edited by bill_dev; 09-13-03 at 22:59.

  3. #3
    Join Date
    Sep 2003
    Posts
    2

    Thumbs up Re: Viewing List of Parameters SP

    Thanks for the info i really appreciate your help.

  4. #4
    Join Date
    Sep 2003
    Location
    Portland, Oregon
    Posts
    11

    Re: Viewing List of Parameters SP

    Originally posted by sidneyfuerte
    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
    Another option is using INFORMATION_SCHEMA.

    Here is an example:

    Code:
    USE pubs
    GO
    
    SELECT *
    FROM INFORMATION_SCHEMA.PARAMETERS
    WHERE SPECIFIC_NAME = 'byroyalty'
    GO

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •