Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

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


  • 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: [email protected]
  • meklemblmeklembl Posts: 107 Bronze 2
    Any progress on this ticket?
    Larry M
    Cleveland, OH USA
Sign In or Register to comment.