Stored Procedure collections

Results 1 to 3 of 3

Thread: Stored Procedure collections

  1. #1
    Franco Guest

    Default Stored Procedure collections

    Is there any way to iterate through all stored procedures through a given DSN. I need to list them all but I have at least 40 and would prefer to write them all to a screen through ASP rather than hardcode them.<BR><BR>T.I.A<BR><BR>Franco

  2. #2
    Join Date
    Dec 1969

    Default RE: Stored Procedure collections

    The following gets a whole bunch of info about all the procs in a given data base.<BR><BR>select * from sysobjects where type=&#039P&#039<BR><BR>I guess you are only interested in the name though.<BR><BR>Hope this is what you meant.

  3. #3
    Garth Guest

    Default RE: Stored Procedure collections

    You can use the system stored procedure: sp_stored_procedures. You can also use the approach mentioned in the other post, but your not suppose to query system tables directly. Using the schema views and system stored procedures provided with the product will ensure that the queries function as expected if future versions of SQL Server change the system tables.<BR><BR>Garth<BR>

Posting Permissions

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