Search not working for a DB

• 
  I've been getting the same thing, just one db being ignored. I came on here looking for the cure - any chance of a response on this?

  Rikster March 27, 2012 03:38

  - 0 +
• 
  I am on XP... you might need to find the index file for whatever system your on. You probably could search My Documents for your server name to find it.. might have to show hidden files.
  
  Navigate to your Application Data\Local Settings folder in your profile, then go to Red Gate > SQLSearch1 > Indexes. You should spot the relevant file in there- delete it (or move it) then reload SSMS, and connect to your instance.

  obperryo March 27, 2012 09:33

  - 0 +
• 
  Aha! Good man, I found the indexes on windows 7 in C:\Users\"username"\AppData\Local\Red Gate\SQLSearch 1\Indexes, removed the lot and presto back to normal.
  
  Many thanks...

  Rikster March 28, 2012 05:35

  - 0 +
• 
  Just to confirm the folder location is here:
  
  C:\Documents and Settings\USERNAME\Local Settings\Application Data\Red Gate\SQLSearch 1\Indexes
  
  the original post had application data then local settings - but its the other way around (confusing as ther is an application data at the same level as local settings).
  
  Dan

  danfountain June 25, 2012 04:48

  - 0 +
• 
  First, thank you for your answers.
  I also had the same problem recently, and your answer fixed my problem.
  
  However, I now have a very serious nagging doubt about all the searches that I have done in the past using SQL Search: What if I missed the update of a field in an SP because the search didn't show it?
  
  Does anyone know if Redgate is looking at fixing this problem in a future release?
  Thank you.

  delbaz February 04, 2013 15:19

  - 0 +
• 
  Thanks for this info. I just experienced the same problem when upgrading to SQL Prompt 8, and this solved it.

  ljanzen June 14, 2017 22:05

  - 0 +
• 
  I have just had this problem too, also now somewhat concerned I have missed things in the past

  Bird July 11, 2017 09:15

  - 0 +
• 
  Same for me. Just did a RedGate update a few weeks ago, problem may be connected to that?

  derVampir September 05, 2017 14:08

  - 0 +
• 
  I recently started getting "No search results" for all searches. I'm on Windows 7 with SQL Prompt v8.0.5.1758

  bml September 07, 2017 06:43

  - 0 +
• 
  Just solved the problem for Windows 10 & SQL Search 3:

  1. Close SQL Server Management Studio
  2. Go to the folder C:\Users\<user>\AppData\Local\Red Gate
  3. Delete the SQLSearch 3 folder
  4. Delete the Logs\SQLSearch 3 folder

  UmbertoA November 03, 2017 08:40

  - 0 +
• 
  I had same problem (SQL Search 3). I solved:
  Create RGTEMP environment variable: C:\Users\<user_name>\AppData\Local\Temp
  

  trinhnguyen July 17, 2019 04:43

  - 0 +

Add comment

Please sign in to leave a comment.