The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
15 views

Search results mismatch after postgresql update [migrated]

Today we had to update the PostgreSQL version on our database servers. Before update the version was 9.3.4 and the new one is 9.3.6. Despite the small difference in the database version and the ...
1
vote
2answers
123 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 ...
2
votes
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, ...
0
votes
1answer
40 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 ...
1
vote
0answers
413 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
4k 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 ...