Running Windows 7 Enterprise (64-bit), the Windows Search fails to find SSMS SQL files saved to a default location that ends up in Dropbox. Some details:
My Documents live under a dropbox-controller folder: C:\Users\david\Dropbox (Personal)\My Documents
SQL Server Management Studio saves files there: C:\Users\david\Dropbox\My Documents\SQL Server Management Studio
This location is supposed to be indexed (went to "Indexing Options", Modify, and made sure that this folder is checked in the list)
Tried re-creating the entire index, no avail
Windows search works in general, including locations in Dropbox, but just not for the SSMS folder!
I wrote a piece of code that uses OLEDB to dump the names of all the indexed files, and indeed, the folder in question was not in the index. What could be causing this? Too long of a path? Some Dropbox weirdness?