SQL Search not finding objects consistently
meklembl
Posts: 107 Bronze 2
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.
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
Cleveland, OH USA
Comments
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.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Cleveland, OH USA