Full Text Index not populating

I have a table with 13,000,000 records. I want to generate a full-text index on one column (a varchar 2000). I am able to define the full-text index, but when I click on "Start Full population", there is virtually no activity (no disk activity, no CPU activity, very little to indicate anything is happening.

When I check the properties of the catalog, it shows 1 MB size and 0 records in the catalog. The status of the catalog is "idle" and the display in EM shows that the last full population occurred at (about) the time that I generated the population request. I have generated the request by using EM (right click on table) and through SQL Agent with the same result (no catalog generated).

I am running SQL 2000 (SP4) on Windows 2000 (SP4) with 4 GB RAM and sufficient disk space available. I have enabled the full-text service and verified that it is running (I have stopped and restarted it as well).

I have worked with Full Text indexes before and never had any kind of issue before. Any thoughts or suggestions would be welcome.

Regards,

hmscott

CREATE TABLE [OMBRE_AUDIT_LOG] (
[LOG_SEQ_NBR] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[APP_NAME] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[USER_ID] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[USER_ORGANIZATION] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ACTION_START_DATE] [datetime] NOT NULL ,
[ACTION_END_DATE] [datetime] NULL ,
[ACTION_CODE] [int] NOT NULL ,
[VIEW_NAME] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[USER_DEF_TRACKING_NBR] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CMD_XML_STREAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[REC_CREATE] [datetime] NULL CONSTRAINT [DF_OMBRE_AUDIT_LOG_REC_CREATE] DEFAULT (getdate()),
[REC_UPDATE] [datetime] NULL ,
[ATTENTION] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[REASON] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
CONSTRAINT [PK_OMBRE_AUDIT_LOG] PRIMARY KEY CLUSTERED
(
[LOG_SEQ_NBR]
)
)
GOPoor scott :D ,

Have u checked any errors in Microsoft Windows 2000 Event Viewer application log which related to Microsft Search?

Another hint is ,

Make sure that the BUILTIN\Administrators login exists in SQL Server.|||Poor scott :D ,

I don't want sympathy, I want answers!!! :D

Have u checked any errors in Microsoft Windows 2000 Event Viewer application log which related to Microsft Search?

Ding! Score 1 point for mallier!


Make sure that the BUILTIN\Administrators login exists in SQL Server.
Ding! Ding! We have a winner!

WTF? Best practice says remove the BUILTIN\Administrator account and yet it's required for this!?! I gotta go read up more on Full text.

Thanks for the help!

Regards,

hmscott|||Hi,
I also got the same problem as you Scott.
I found I have the BUILTIN\Administrator in SQL Server.

So what will be the reason?|||To access existing full-text search catalogs, rebuild and repopulate them. The existing catalogs can also be accessed by switching back to an administrator account.|||Hi Satya,

I have the exact problem as Scott, could you give me some idea how to solve the problem please?