I'm using SQL Server Management Studio (2008) to connect to my Winhost DB. When trying to create a full text index via the wizard (by right-clicking on the table and selecting the appropriate option) I get the following error during the 'Define Population Schedules' option. I was eventually able to create such an index by editing the index directly rather that going through this wizard, but I don't know whether I now have the same configuration on your servers as I do on my dev box.
Are you sure you connected to our database. Base off the error message it looks like you are trying to connect to the system database. Also try reviewing this knowledge base for an example on how to setup Full-Text catalog. http://support.Winhost.com/KB/a889/creating-full-text-catalogs-indexes-with-management-studio.aspx
Hi Ray, Yes I was connected to the correct database. If you use the wizard in the way I describe (the most obvious way to create such an index) then it fails. However if you do it in the way described in the KB article you linked to (non-wizard), it works. Must be that the wizard assumes access to system tables and irrecoverably fails when it can't get what it wants. No idea why. Just thought you'd like to know. I'm sure most folks who want to set up full text indexing and don't do it via SQL would hit this problem. All the best, Drew.