Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102

    Unanswered: List all Stored Procedures used in a VS.NET project

    Hi

    This is kind of a visual studio question, but pertinent to db' s - due to many changes of our application I know that there are many stored procs in the database that are no longer used. Since I cannot get a list from the programmers, is there any way to get a list out of visual studio, of every SQL stored procedure called in that project? (Going through each form manually will just be too time consuming for me or the programmers)

    Anyone know any tricks??
    thx
    Des

  2. #2
    Join Date
    Dec 2003
    Location
    Delhi INDIA
    Posts
    58
    this query can list all the stored procedure names that ur db has....

    select name from YOURDBName..sysobjects where xtype='P'
    Deep..

    MCDBA
    ------------------------------------------
    How much data you can afford to lose??

  3. #3
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102
    Sorry, you misundertand - I need to list the procs used in a Visual Studio project, not in a DB..(as I know a lot are not used anymore and want to clean out my db)

Posting Permissions

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