Questions tagged [full-text-catalog]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers
813 views

Rebuild of fulltext catalog is very slow

I have recently added iFilters to my SQL Server and configured a FullText catalog to index a blob column on a database with 1.4 mil records. The SQL server is running in a production environment with ...
Johny Skovdal's user avatar
1 vote
2 answers
136 views

sql 2005 fulltext catalogs inaccessible

Recently, and without any errors in the logs, my fulltext catalogs have stopped responding. I can't disable/delete/rename them. SSMS reports a generic error (1222) and using sql commands in the query ...
Paulj's user avatar
  • 111
5 votes
1 answer
3k 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, ...
Sam's user avatar
  • 2,030
0 votes
1 answer
50 views

SQL 2005: Backup database but ignore FTI Catalog

Folks, Apologies for aksing what might be a very simple question, but can I backup a database and ignore the databases FTI catalog? These backups will be restored to a different server and the ...
Binary Worrier's user avatar
1 vote
0 answers
497 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 ...
Bill Paetzke's user avatar
4 votes
1 answer
8k 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 ...
Bill Paetzke's user avatar
1 vote
2 answers
15k 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 ...
Kyle Noland's user avatar
  • 1,039