hello
my full text queries have suddenly stop functioning,when I press execute tab,
its keep on saying "Executing query" for hours.Can any one tell me how to
resolve this problem.
I am using SQL server 2005.In the enterprise manager, I can see Full Text
Search icon under Management
I tried executing some queries again...
when I execute
CREATE FULLTEXT CATALOG charlottecatalog
it says this catalog already exist..as I creates it.

CREATE Unique Index ui_TextElement on TextElement(SystemElementID)

it says index already exist ...as I created it before

Create fulltext index on TextElement(ElementText TYPE COLUMN ntext )
Key index ui_TextElement on charlottecatalog
with change_tracking auto

BUT in this case again it says "Executing query"...and no result!!!!

I also tried doing the following.creating another index,in case 1st one have
some problem
CREATE Unique Index ui_NEWTextElement on TextElement(SystemElementID)
It says index created.

But when I try to execute this
Create fulltext index on TextElement(ElementText TYPE COLUMN ntext )
Key index ui_NEWTextElement on charlottecatalog
with change_tracking auto

again it says "Executing query"...and no result!!!!

what could be the possible reason for this......I am badly stuck...as due to
this I cannot proceed my task...

Please help me resolve this.

i forgot to tell something, A new table is added in the database,could that
be the possible reason????

I also  tried to create a new catalog by dropping the old.

when I execute he query    Drop Fulltext Catalog charlottecatalog;

It says Cannot drop full-text catalog 'charlottecatalog' because it contains
a full-text index.

So then I started dropping the index,   Drop Fulltext Index on TextElement
Then it says executing query for long hours,I dont know how long but after
sometime I just cancel it

Now tell me what to do .......PLEASE.

I also check sql 2005 configuration manager ,all the server state is running,
I also restarted it,but then also no solution.

I have one question,once we create catalog and indexes,then if there are
changes in database,like adding new table or adding new data to some columns,
will these hamper  full text searching.It means everytime there is change,
then what should I do.

I use change traking auto.

The full text queries contains,freetext were working fine,all of a sudden
from ast 1 week now i facing this problem

Thank You.