What are the challenges you face when working across database platforms? Take the survey

SQL Search not finding objects consistently

meklemblmeklembl Posts: 107 Bronze 2
edited October 7, 2013 1:30PM in SQL Prompt
I just upgraded my PC to the new version of SQL Toolbelt which included SQL Prompt ( and SQL Search (

I have a view in my production database called SearchMaster.

When I use SQL Search to find SearchMaster in the database, it does not. It finds other objects that contain SearchMaster, but not the actual view.

When I change the search criteria and check the "Exact Match" then the view SearchMaster is in the resulting list.

I would expect it to appear in both cases.
Larry M
Cleveland, OH USA


  • Options
    Anu DAnu D Posts: 876 Silver 3
    Thanks for your post and apologies for the inconvenience caused.

    Can you try these steps in order to fix this issue?

    1. Close SSMS
    2. Navigate to %USERPROFILE%\AppData\Local\Red Gate\SQLSearch 1\Indexes
    3. Delete all the files here
    4. Open SSMS and try to replicate the issue.

    Let me know if this solves the issue for you.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    meklemblmeklembl Posts: 107 Bronze 2
    Any progress on this ticket?
    Larry M
    Cleveland, OH USA
Sign In or Register to comment.