Not working well

tshad · July 3, 2019 9:47PM

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 · July 8, 2019 5:47PM

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 · July 9, 2019 12:48PM

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

squigley · July 11, 2019 5:28PM

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 · July 12, 2019 12:44PM

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

tshad · July 12, 2019 6:15PM

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 · July 24, 2019 3:54AM

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

tshad · July 24, 2019 6:46PM

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

Not working well

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk