Menu
I am trying to enable Full-text indexing in SQL Server 2005 Express. I am running this on my laptop with Vista Ultimate.
I understand that the standard version of SQL Server Express does not have full-text indexing. I have already downloaded and installed "Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 2" (download).
I have also ensured that both the "SQL Server (instance)" and "SQL Server FullText Search (instance)" services are running on the same account which is "Network Service".
I have also selected the option to "Use full-text indexing" in the Database Properties > Files area.
I can run the sql query "SELECT fulltextserviceproperty('IsFulltextInstalled');" and return 1.
The problem I am having is that when I have my table open in design view and select "Manage FullText Index"; the full-text index window displays the message...
"Creation of the full-text index is not available. Check that you have the correct permissions or that full-text catalogs are defined."
Any ideas on what to check or where to go next?
881
In Management Studio, in Object Explorer, expand the server. Expand Databases, and then expand the database that contains the full-text index. Expand Tables. Right-click the table on which the full-text index is defined, select Full-Text index, and on the Full-Text index context menu, click Properties.
A: You can determine if Full-Text Search is installed by querying the FULLTEXTSERVICEPROPERTY like you can see in the following query. If the query returns 1 then Full-Text Search is enabled.
In Object Explorer, expand the server, expand Databases, and expand the database in which you want to create the full-text catalog. Expand Storage, and then right-click Full Text Catalogs. Select New Full-Text Catalog.
Create FULLTEXT index using CREATE TABLE statement. To create the FULLTEXT index, you place a list of comma-separated column names in parentheses after the FULLTEXT keyword. The following statement creates a new table named posts that has a FULLTEXT index that includes the post_content column.
sp_fulltext_database 'enable'
CREATE FULLTEXT CATALOG [myFullText]
WITH ACCENT_SENSITIVITY = ON
CREATE FULLTEXT INDEX ON [dbo].[tblName] KEY INDEX [PK_something] ON [myFullText] WITH CHANGE_TRACKING AUTO
ALTER FULLTEXT INDEX ON [dbo].[otherTable] ADD ([Text])
ALTER FULLTEXT INDEX ON [dbo].[teyOtherTable] ENABLE
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
