Hi muser,

Good to hear you've got the full text searching on - it's very powerful and really makes hitorical helpdesk data come alive.

HelpMaster has been hard-coded to only search on certain database tables. That's why it is appropriate to only full text index the tables you've mentioned. Although it's possible to index every text column in every table, this will be a waste, because HelpMaster will never use those indexes.

You might find that populating every week might be a bit too much of a time lag. SQL Server does a good job of automatic re-indexing every time the table is updated. This means that your full text catalogs will be right-up to date, instead of having to wait a week for accurate results.

The full text script found in the knowledge base will setup and configure everything you need.

https://prdsoftware.com/h...Article.aspx?view=31

An alternative method of setting it up is to use the Database and Reports Wizard. Select the "Tools" option on the first screen and follow the prompts until you get to the full text screen.

Hope this helps - let us know how you go with it.

OK thanks. I wondered about the schedule part. I'll amend that. But I love the results I get now from using FTS and I can't believe we hadn't implemented it earlier.

FTS is pretty cool. Definately a must-do for any helpdesk.