Post reply

Object Search

  • May 1, 2009 at 11:49 am

    #220816

    Comments posted to this topic are about the item Object Search

  • July 3, 2012 at 3:27 pm

    #1508513

    I think it is worth noting that the @v_Search_String parameter should not contain any wildcards (i.e., %) as the stored procedure adds that to the parameter. I didn't realize that at first and was not getting anything back on my test system when I knew the string existed. Going through the code, I quickly discovered that the wildcards are added to the string in the parameter for you and my adding them caused it to read the wildcard as a literal character that was part of the search string.

  • July 3, 2012 at 4:00 pm

    #1508533

    When I originally designed the procedure it actually functioned the way you wanted it to. After a peer review with some colleagues, they all argued for the opposite (never can win it seems LOL). Since you've familiarized yourself with the code you should be able to adjust it to fit your needs.

    Thanks for the feedback.

  • July 3, 2012 at 5:10 pm

    #1508542

    No problem. That works fine for me, just needed to figure it out and wanted to let everyone else know how to pass the search string parameter to the stored procedure so they don't run into the same thing.

  • July 3, 2012 at 5:36 pm

    #1508544

    Good idea and thanks for posting this. I may end up adding a "use or search" for wildcards switch in a later version. This would make it more flexible.

  • October 18, 2012 at 6:31 am

    #1550421

    I'm not clear if this will allow for searches within SSIS packages?

  • October 18, 2012 at 11:15 am

    #1550621

    Honestly, never tried (but I would think no). Sorry, haven't dealt much with SSIS packages. Try a search string that you know is in an SSIS package and see if it brings back any results. Post the results if you don't mind.

  • June 20, 2014 at 6:08 am

    #1723556

    Hi, I am trying to search a string from the object definitions like this and getting no result

    EXECUTE dbo.usp_Object_Search

    @Search_String = N'fiscal/2'

    ,@Database_Name = N'Test'

    ,@Search_Against = 'D'

    Above Test is my database name and fiscal/2 is the string in one of the stored procedures. Please help, this is looking awesome procedure if it work for my situation.

    Thanks

  • June 21, 2014 at 6:47 pm

    #1723820

    Moneer-479830 (6/20/2014)

    Hi, I am trying to search a string from the object definitions like this and getting no result

    EXECUTE dbo.usp_Object_Search

    @Search_String = N'fiscal/2'

    ,@Database_Name = N'Test'

    ,@Search_Against = 'D'

    Above Test is my database name and fiscal/2 is the string in one of the stored procedures. Please help, this is looking awesome procedure if it work for my situation.

    Thanks

    Is the database in question case sensitive?

  • September 25, 2014 at 6:51 am

    #1748134

    Does this procedure also pick up Indexes? It does not look like it in the Valid Object type list. How can I add Indexes to this search?

  • September 25, 2014 at 7:09 am

    #1748139

    No, it does not search against indexes. You would need to add that to the script unfortunately.

  • December 23, 2015 at 5:07 am

    #1847672

    Haven't tried it yet but wondering about the duration for a search.

  • December 23, 2015 at 7:30 am

    #1847727

    It depends mainly on what you're searching for, the size of the database, and the filtering options you use.

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply