Hi,
Just to ensure that there are no indexes run the following code in SQL Server Manager:
if (exists (SELECT name FROM sys.fulltext_catalogs where name = N'ftcat_documentindex') )
begin
DROP FULLTEXT INDEX ON DocumentIndex;
DROP FULLTEXT CATALOG ftcat_documentindex
end
Then run the following code (replace <organisation> with your own organisation name):
use <organisation>_MSCRM
go
exec sp_fulltext_database 'enable';exec sp_fulltext_catalog 'ftcat_documentindex', 'create';
exec sp_fulltext_table 'dbo.documentindex', 'create', 'ftcat_documentindex', 'cndx_PrimaryKey_DocumentIndex';
go
exec sp_fulltext_column 'documentindex', 'Title', 'add';
go
exec sp_fulltext_column 'documentindex', 'KeyWords', 'add';
go
exec sp_fulltext_column 'documentindex', 'SearchText', 'add';
go
exec sp_fulltext_table 'documentindex', 'activate';
go
exec sp_fulltext_catalog @ftcat='ftcat_documentindex', @action='Rebuild';
go
exec sp_fulltext_catalog @ftcat='ftcat_documentindex', @action='start_full';
go
Henrik Jensen
Instructor / Consultant
MCP, MCAD, MCSD, MCTS, MCPD, MCITP, MBSS, MBSP, MCT
www.crmblog.dk (Danish only)
