Questions tagged [full-text-catalog]
7 questions
5
votes
1 answer
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, but this one has me stuck.
Trying to populate…
![](../../users/profiles/2608.webp)
Sam
- 1,990
- 1
- 14
- 21
4
votes
1 answer
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 have permission to perform this action.
FYI--
I…
![](../../users/profiles/20656.webp)
Bill Paetzke
- 855
- 4
- 12
- 19
1
vote
0 answers
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 a lot of load, but mostly during daytime.
The…
![](../../users/profiles/128597.webp)
Johny Skovdal
- 123
- 9
1
vote
2 answers
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 window to remove the fulltext catalogs results in…
![](../../users/profiles/778.webp)
Paulj
- 111
- 4
1
vote
0 answers
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 MyCatalog /* I want MyCatalog to be default, so I…
![](../../users/profiles/20656.webp)
Bill Paetzke
- 855
- 4
- 12
- 19
1
vote
2 answers
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 existing catalog. How do I find out the name of an…
![](../../users/profiles/3497.webp)
Kyle Noland
- 1,039
- 3
- 19
- 21
0
votes
1 answer
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 FTI Catalog isn't…
![](../../users/profiles/2268.webp)
Binary Worrier
- 133
- 1
- 6