Professional Web Applications Themes

search for stored procedures with certain text - Microsoft SQL / MS SQL Server

Hi, I want to search for how many stored procedures a table has been called in SQL Server 7.0. Is there any way I can run a query to get the result against the system tables? Appreciate any help! Shane...

  1. #1

    Default search for stored procedures with certain text

    Hi,

    I want to search for how many stored procedures a table
    has been called in SQL Server 7.0. Is there any way I can
    run a query to get the result against the system tables?

    Appreciate any help!

    Shane
    Shane Guest

  2. #2

    Default Re: search for stored procedures with certain text


    "Shane" <com> wrote in message
    news:01cf01c35dec$16b5bce0$gbl... 

    select * from syscomments
    where text like '%mytable%'

    David


    David Guest

  3. #3

    Default Re: search for stored procedures with certain text

    Select object_name(id)
    from syscomments
    where text like '%mytablename%'

    if you are not using this table in dynamic SQL try

    sp_depends 'TableName'

    HTH
    Srinivas Sampangi



     [/ref]
    can 
    >
    >select * from syscomments
    >where text like '%mytable%'
    >
    >David
    >
    >
    >.
    >[/ref]
    sampangi Guest

  4. #4

    Default Re: search for stored procedures with certain text

    Thank you very much!
     [/ref]
    can 
    >
    >select * from syscomments
    >where text like '%mytable%'
    >
    >David
    >
    >
    >.
    >[/ref]
    Shane Guest

  5. #5

    Default Re: search for stored procedures with certain text

    There was a thread about this on Jul. 25: http://tinyurl.com/jgap




    "Shane" <com> wrote in message
    news:01cf01c35dec$16b5bce0$gbl... 


    Aaron Guest

  6. #6

    Default Re: search for stored procedures with certain text

    And also tables that are dropped and re-created after the stored procedure
    exists...
     


    Aaron Guest

Similar Threads

  1. Stored Procedures
    By Anthony M. Davis in forum Coldfusion - Advanced Techniques
    Replies: 28
    Last Post: February 9th, 03:17 PM
  2. dt_ Stored Procedures
    By chopper in forum ASP Database
    Replies: 2
    Last Post: July 20th, 04:06 PM
  3. New to ASP and Stored Procedures
    By John Berman in forum ASP Database
    Replies: 6
    Last Post: February 28th, 01:37 AM
  4. SQL-DMO and stored procedures
    By in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 24th, 02:46 PM
  5. Need help about stored procedures
    By Tahir in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 23rd, 10:17 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139