Home Forums Article Discussions Article Discussions by Author Discuss content posted by Kshitij Satpute Simplest way to search any string in db objects RE: Simplest way to search any string in db objects

  • August 8, 2013 at 9:46 am

    #1639860

    dbajunior (8/8/2013)

    Description: This procedure will allow you to find any string in any DB Object with its name or part of its name.

    It will also allow you to find the column name belongs to which tables, TV functions and Views.

    Not picking up any table objects for some reason. Does check procs, views, triggers and functions.

    Sorry for adding this line It will also allow you to find the column name belongs to which tables, TV functions and Views.

    I removed this part of code because there were performance issues. Will add it to the SP once I optimize it. Thanks for pointing out the mistake, feedback is always welcome.