I have tried to add full-text indexing on one of the database's on my sql server. When I right click on the FORUM_TOPICS table select Full-Text Index Table --> Define Full-Text Indexing on a Table then I get the following error message.
The selected table has no unique single column index on a column that does not allow NULLS
I can seem to find anything that is wrong on the table that would not allow me to add this. Anyone have any ideas?
Can you elaborate on how you got full text indexing to work? I.e. how did you create an index/key for each table? I'm getting timeouts when I try and do an update Forum count and I think this will help dramatically.
fulltext engine requires a distinct single-column key to return a set of matches (and their ranks) - I don't think it'd help you with the forum count per se...
what kind of numbers are you talking about - a few thousand, a few million or a few billion? there may be indexing optimisations you can make, or there may be other blocks...