1
vote
1answer
1k views

SQL Full-Text indexing not populating

We installed a clustered SQL 2005 installation on windows 2008 and reattached our san drives from another machine and restored to do a migration to new hardware. There have been a few minor issues, ...
1
vote
0answers
223 views

Alter Fulltext Catalog Reorganize: Any issues to run this during daytime?

I have been going thru documents on Alter Fulltext Catalog Reorganize. But unlike Alter Index Reorganize, BOL(Books Online) documentation does not mention whether it's possible to run it without ...
1
vote
0answers
410 views

How to create full-text catalog as default catalog?

This would save me the redundant ON MyCatalog phrase when I create full-text indices. For example, CREATE FULLTEXT INDEX ON MyTable ( MyField1, MyField2, MyField3 ) KEY INDEX PK_MyKey ON ...
3
votes
1answer
3k views

How to get permission to create full-text index?

I tried to create a full-text index on my new full-text catalog and got this error: Msg 9967, Level 16, State 1, Line 1 A default full-text catalog does not exist in database 'foo' or user does not ...
0
votes
2answers
3k views

How do you find the name of an existing full text catalog in SQL Server 2008 Express?

I have SQL Server 2008 Express installed. Several months ago I created a full text catalog and index. I would like to index some additional table columns now, but I can't remember the name of the ...