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