Not working well

tshad

I cannot typically get results using this anymore.  It used to work real well.  For example, I have "PATH" as my search and no matter what object types I choose or whole words or wildcards, I get nothing back.

Obviously, this is in many of my stored procedures.  I use it to get comma delimited strings.

squigley

Good Morning!

Can you confirm what version of SQL Search that you're seeing this under?

Can you try the troubleshooting steps from the below documentation to see if that helps?

https://documentation.red-gate.com/ss3/troubleshooting/the-search-results-aren-t-what-i-expected

IamCornholio

I am getting the same.  SQL Search no longer working with new update 3.2.7.2379.  I have tried re-indexing.

squigley

Do you have any other Redgate products installed, in particular SQL Prompt?  If the answer is yes, what version of SQL Prompt is currently installed?  

I ask this question, due to updates to SQL Search performed in March 2019, where a later version of SQLite libraries conflicted with the SQLite libraries used in SQL Prompt which resulted in the 'SQLite.Interop.dll' errors similar to the one found in your log file.  If using SQL Prompt V9.4.12.8426 or earlier, I recommend that you upgrade to at least V9.4.16.9097 of SQL Prompt.

Let me know if that helps you out.

IamCornholio

Hi Squiqley, that worked!  Thank you for the help on this.

tshad

I am running SQL Search 3.2.7.2379 and SQL Prompt 9.5.8.10521.  I also search on "SELECT" and that doesn't work.  I also reindexed and that doesn't seem to help.

tshad

I just loaded the newest version of SQL Prompt and I still get nothing back.  It is not working at all.

tshad

I don't know if it matters but I am on SQL Server 2008 R2.