Not returning results when they are there.

I am trying to find any results on a value iMenuItem_id.

I know that exists. I do a select on a table that has it - and it is there. But SQLSearch is showing nothing.

I have it set for all object types, matches on all and tried it with match with whole word checked and unchecked.

tshad March 18, 2019 17:40

Comments

3 comments

Thank you for contacting Redgate support.
The issue here might be caused by cached index files that are in a bad state. Can you please:
- Close SSMS
- Delete all content from the folder %LocalAppData%\Red Gate\SQLSearch 2\Indexes
- Reboot
- Open SSMS, go to the SQL Search tab and then try searching again
Thanks,
Pejman
Pejman March 20, 2019 08:47

0
Unfortunately, this may due to the recently introduced breaking update.

Please see this thread;
https://forum.red-gate.com/discussion/84956/sql-search-not-returning-any-results

evanfantr March 20, 2019 17:54

0
If you have SQL Prompt installed, can you try upgrading to the latest version to see if that helps?
ftp://support.red-gate.com/patches/SQLPrompt/08Apr2019/SQLPrompt_9.4.16.9097.zip

This should have been fixed as of the 9.4.14 version.

Thanks!

squigley April 08, 2019 23:31

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Not returning results when they are there.

Comments

Add comment