SQL Search not finding objects consistently

meklembl

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.

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.

meklembl

Any progress on this ticket?