If your DNN database size has grown out of control, the following article might help you. It is about the search feature creating excessive entries in database and how to clear the index out to reclaim the space.

Credits to Will Strohl.
http://www.willstrohl.com...ing-the-Search-Index

TRUNCATE TABLE [dbo].[SearchItemWordPosition]

DELETE FROM [dbo].[SearchItemWord]

DELETE FROM [dbo].[SearchWord]

DELETE FROM [dbo].[SearchItem]




And here is a second link that shows us how to clear the search index tables without truncating them.

http://weblogs.asp.net/ch...r-Search-Tables.aspx

delete SearchItemWordPosition where SearchItemWordId in (select SearchItemWordId from SearchItemWord where SearchItemID in (select SearchItemId from SearchItem))
delete SearchWord where SearchWordsId in (select SearchWordsId from SearchItemWord where SearchItemID in (select SearchItemId from SearchItem))
delete SearchItemWord where SearchItemId in (select SearchItemId from SearchItem) delete SearchItem


here's objectQualifier included code

delete {objectQualifier}SearchItemWordPosition where SearchItemWordId in (select SearchItemWordId from {objectQualifier}SearchItemWord where SearchItemID in (select SearchItemId from {objectQualifier}SearchItem))
delete {objectQualifier}SearchWord where SearchWordsId in (select SearchWordsId from {objectQualifier}SearchItemWord where SearchItemID in (select SearchItemId from {objectQualifier}SearchItem))
delete {objectQualifier}SearchItemWord where SearchItemId in (select SearchItemId from {objectQualifier}SearchItem) delete {objectQualifier}SearchItem