2
votes
0answers
130 views

Full Text Search query elapsed time varying wildly

Database Version: Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 ...
0
votes
2answers
275 views

High MSSEARCH Wait Type in SQL Server 2005

This week I've run into a problem with the MSSEARCH wait type, and I haven't been able to fully diagnose the problem. The server had been running with no problem for several weeks until the other ...
1
vote
0answers
408 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
1answer
457 views

How do I modify the thesaurus for full-text-indexing in SQL 2005?

So I've read this: http://www.simple-talk.com/sql/learn-sql-server/understanding-full-text-indexing-in-sql-server/ And I've made the following modification to the tsENU.xml file to include the ...
8
votes
3answers
8k views

How to detect if full text search is installed in SQL Server

I need to find out if full text search is installed on SQL Server 2005. I don't have permission to log into the box and fire up Setup to check. However I can run SQL Server Management Studio and ...