Jaffar
USE YourDatabase
GO
EXEC sp_fulltext_database 'enable'
GO
CREATE FULLTEXT CATALOG [CatalogName]
IN PATH N'D:\MSSQL\FTDATA'
WITH ACCENT_SENSITIVITY = OFF
GO
CREATE FULLTEXT INDEX ON [dbo].[YourTable](
[ColumnToIndex] LANGUAGE [Neutral])
KEY INDEX [PK_YourTable] ON [CatalogName]
WITH CHANGE_TRACKING AUTO
GO
ALTER FULLTEXT INDEX ON [dbo].[YourTable]
START FULL POPULATION
GO
Look all these up in the Books Online, of course, to review the parameters
and settings.
RLF
> From start to finish, what queries do I give to enable fulltext (if
> not enabled), create catalog, create and populate index for a table?
> I do not want to use any UI for this. I'm using SQL 2005.
>
> Regards,
> --Jaffar