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 220.127.116.112 (but I've tried different ones)
Thanks for your help!