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
没有评论:
发表评论