Red Gate forums :: View topic - SQL Search only searches modified objects
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

SQL Search only searches modified objects

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



Joined: 07 Jun 2011
Posts: 3

PostPosted: Tue Jun 07, 2011 8:24 am    Post subject: SQL Search only searches modified objects Reply with quote

Hi all,

I'm a big fan of SQL Search, but it's lettingme down lately.

I have a strange problem: it seems that SQL Search can only search in objects that are modified since a certain day or something.

If I do a search now, it gives all kinds of results, but for example it misses a lot of objects like procedures. If I then go to a missing procedure and execute an ALTER on it (even when not really changing anything), then the contents of that procedure can be found again by SQL Search.

Does this sound familiar?

Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Analysis Services Client Tools 10.50.1600.1
Microsoft Data Access Components (MDAC) 6.1.7600.16385
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.7600.16385
Microsoft .NET Framework 2.0.50727.4959
Operating System 6.1.7600

SQL Search 1.0.0.342 (but I've tried different ones)

Thanks for your help!
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 690
Location: Cambridge

PostPosted: Mon Jun 13, 2011 11:55 am    Post subject: Reply with quote

Many thanks for your post and apologies for inconvenience caused.

Looks like some issue with the cache. Have you tried 'Force reindex'?

If you still see this issue can you also try manually deleting the index files and then try replicating the issue after that?

You can find the index files here: %USERPROFILE%\AppData\Local\Red Gate\SQLSearch 1\Indexes

Let me know how it goes.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
SonOfGrey



Joined: 07 Jun 2011
Posts: 3

PostPosted: Mon Jun 13, 2011 9:35 pm    Post subject: Reply with quote

Many thanks for that suggestion. I wasn't aware of the fact that there were index files that I could delete!

I tried refreshing and force reindexing many times, but it didn't helpt. Also reinstalling etc.

I really hope that removing the index files helps. I will try this first thing tomorrow and I'll let you know how it works out.
Back to top
View user's profile Send private message
SonOfGrey



Joined: 07 Jun 2011
Posts: 3

PostPosted: Thu Jun 16, 2011 9:11 am    Post subject: Reply with quote

So far removing the index files fixed the problems!

Of course I don't know what caused it, and I hope it was just a one time incident.

Thanks for offering a solution!
Kind regards
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 690
Location: Cambridge

PostPosted: Thu Jun 16, 2011 12:56 pm    Post subject: Reply with quote

No problem!

I am glad that your issue is resolved :)
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
delbaz



Joined: 04 Feb 2013
Posts: 2

PostPosted: Mon Feb 04, 2013 9:22 pm    Post subject: SQL Search only searches modified objects 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
ckosti



Joined: 02 Jul 2013
Posts: 2

PostPosted: Tue Jul 02, 2013 7:19 pm    Post subject: Reply with quote

I just ran into this issue too, where some stored procedures were missing from the results and refresh/force reindex did not fix the problem. Deleting the cache files worked for me as well.

I also have the same concerns as delbaz. I've grown a little bit dependent on SQL Search for tracking down references and dependencies, so incomplete results are a big problem.
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