Menu

Search

InstantASP Support

Help & Support


Full-text table or indexed view has more than one LCID among its full-text indexed columns


Common Questions

After enabling SQL Server full text indexing on the InstantKB_Attachments table you may receive the following error...

 Full-text table or indexed view has more than one LCID among its full-text indexed columns

This can occur if the language breakers set for each column within the InstantKB_Attachments table are not consistent when defining the index. 

To resolve this problem you'll need to right click the InstantKB_Attachments table within SQL Server Management Studio and goto the Properties option under the "Full Text Index" option as shown below...

Within the Properties dialog select "Columns". You'll see your language breakers are not consistent as shown below...

To resolve the error simply click within the language (or work breaker) column and select the correct language to ensure consistency. For example...

That's It!

We hope this article helps resolve the detailed  problem. If this issue continues for you with either InstantForum or InstantKB please don't hesitate to open a support ticket or contact us.


Optionally provide private feedback to help us improve this article...

Thank you for your feedback!


Comments require login or registration.

Details

Product: InstantKB
Version: All Versions
Type: HOWTO
Level: Novice
Article not rated yet.
Article has been viewed 22K times.
Last Modified: 5 Years Ago
Last Modified By: Ryan Healey

Options

Similar Articles


Tags