Red Gate forums :: View topic - Search not working for a DB
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Search 1
SQL Search 1 forum

Search not working for a DB

Search in SQL Search 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
obperryo



Joined: 13 Mar 2012
Posts: 2

PostPosted: Tue Mar 13, 2012 8:32 pm    Post subject: Search not working for a DB Reply with quote

I have been using SQL Search successfully for a while.
At one time I was having trouble searching but it fixed itself.
Again I am having trouble searching…. And it looks like it is not searching one of my DB’s - get no results. I have tried re-indexing and force re-index with no luck. I also tried uninstalling and reinstalling.. with no luck.
Any suggestions?
Back to top
View user's profile Send private message
Rikster



Joined: 27 Mar 2012
Posts: 2

PostPosted: Tue Mar 27, 2012 8:38 am    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
obperryo



Joined: 13 Mar 2012
Posts: 2

PostPosted: Tue Mar 27, 2012 2:33 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Rikster



Joined: 27 Mar 2012
Posts: 2

PostPosted: Wed Mar 28, 2012 10:35 am    Post subject: Reply with quote

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...
Back to top
View user's profile Send private message
danfountain



Joined: 25 Jun 2012
Posts: 8

PostPosted: Mon Jun 25, 2012 9:48 am    Post subject: I had this too... Reply with quote

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
Back to top
View user's profile Send private message
delbaz



Joined: 04 Feb 2013
Posts: 2

PostPosted: Mon Feb 04, 2013 9:19 pm    Post subject: Search not working for a DB Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group