<p>Has anyone used Lucene.NET rather than using the full text search that comes with sql server?</p>

<p>If so I  would be interested on how you implemented it. </p>

<p>Did you for example write a windows service that queried the database every hour then saved the results to the lucene.net index?</p>

I have not done it against database yet, your question is kinda open.
If you want to search an db, and can choose to use Lucene, I also guess that you can control when data is inserted to the database.
If so, there is little reason to poll the db to find out if you need to reindex, just index as you insert, or create an queue table which can be used to tell lucene what to index.
I think we don't need another indexer that is ignorant about what it is doing, and reindexing everytime, or uses resources wasteful.