How can we help you today? How can we help you today?

SQL Search not finding objects consistently

I just upgraded my PC to the new version of SQL Toolbelt which included SQL Prompt (6.0.0.441) and SQL Search (1.1.9.57).

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.
meklembl
0

Comments

2 comments

Sort by
  • Anu D
    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.
    Anu D
    0
  • meklembl
    Any progress on this ticket?
    meklembl
    0

Add comment

Please sign in to leave a comment.