SitePoint Sponsor

User Tag List

Results 1 to 1 of 1
  1. #1
    SitePoint Zealot Bruce Lee's Avatar
    Join Date
    Jan 2005
    Location
    Singapore
    Posts
    198
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    how to search a string in existing Stored Procedure, views, jobs

    I was given an application which doesnot have a documentation.
    It is done in asp using SQL2000.
    I have no idea where and how the column, tables are effected.

    I can make a global search for the table or column name in asp to find out the flow to some extent.

    but how can i make a search for perticular table name in all the existing stored procedures,views,jobs ???

    cuz most of the transactions are inside the SP and i want to find them all in single search.

    Is there any option in SQL like find/find all where i can make a search?

    or

    any other way??
    Last edited by Bruce Lee; Feb 21, 2006 at 22:28. Reason: typo
    Happy Coding!!!
    Bruce Lee.


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
  •