2012年3月9日星期五

Full Text hangs Enterprice manager

hi,

I am using MS SQL Server 2000 SP3a on windows server 2000.

I have 4 FT indexs on 4 of my tables.
They are schedules to run every day once. For the last couple of days the jobs are hanged.

When I tried to open Catalogs by clicking on 'Full Text Catalogs' enterprice manager hangs( not responding). I had to go to taskmanager and then click on end task to re-open the enterprise manager.

Also when I right click on one of the tables enabled with FT indexing
Enterprise manager hangs up again.

If I cannt open FTCatalogs how can I rebuild them.

please respond,
mpkcontd..to my previous post

Also in my ErrorLog file i see the following messages,

2007-03-30 06:20:04.08 spid56 WARNING: EC 237815d8, 0 waited 187500 sec. on latch ad8c88. Not a BUF latch.
2007-03-30 06:20:04.08 spid56 Waiting for type 0x4, current count 0xa, current owning EC 0x59E49550.

thanx in adv,
mpk|||you can try rebuilding them using t-sql. see books online for syntax.|||Are you trying to do this while the database is not in single user mode...sorry, never have done full text myself

没有评论:

发表评论