Click here to Skip to main content
15,886,753 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
hi...
when i create catalog its give me following error
"The Full-Text Service (msftesql) is disabled. The system administrator must enable this service."

i used statement for creating catalog " exec sp_full-text_Catalog N'test' ,N'create'
go"


thanks
Posted

1 solution

[]Hi
following one will work
SQL
-- Enable fulltext searching on the database
USE database1;
GO
EXEC sp_fulltext_database 'enable';
GO
-- Create a fulltext catalog
CREATE FULLTEXT CATALOG ft_catalog_database1
GO



CREATE FULLTEXT INDEX ON database1.dbo.poems
(
	title--->Column name
	Language 0X0,
	poem----->Column name
	Language 0X0
)
KEY INDEX PK__poems__00551192 ON ft_catalog_database1
WITH CHANGE_TRACKING AUTO; 

here
PK__poems__00551192---->its index key

Take help from this also if u want more:http://www.youdidwhatwithtsql.com/sql-server-fulltext-search-primer/248[^]
 
Share this answer
 
v3
Comments
vivek_cool 12-Aug-11 2:02am    
hey thanks for your reply
but when i write this"CREATE FULLTEXT CATALOG ft_catalog_database1
GO" then its give me error "The Full-Text Service (msftesql) is disabled. The system administrator must enable this service."
Tajuddin_HYD 12-Aug-11 2:06am    
did u enable ur database if so then also ur getting,then go with admin login it will work

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900