Full-Text Search SQL Server 2005

Full Text search in SQL Server 2005/2008

You can find more about full text search at below mentioned URL.

http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/

http://blog.sqlauthority.com/2009/12/26/sql-server-whitepaper-sql-server-2008-full-text-search-internals-and-enhancements/

How to enable Full-text Indexing in SQL Server 2005 Express?

sp_fulltext_database 'enable'

CREATE FULLTEXT CATALOG [myFullText]
WITH ACCENT_SENSITIVITY = ON

CREATE FULLTEXT INDEX ON [dbo].[tblName] KEY INDEX [PK_something] ON [myFullText] WITH CHANGE_TRACKING AUTO
ALTER FULLTEXT INDEX ON [dbo].[otherTable] ADD ([Text])
ALTER FULLTEXT INDEX ON [dbo].[teyOtherTable] ENABLE

Searching numeric strings with Full-Text Search in SQL 2005

I eventually found the reason behind this.

Numerics are considered as noise words in SQL server. You can allow searching on numerics by removing the numeric entries in the appropriate noise file for your language.

Noise files are found at in the FTData directoraty of your SQL Server install.

The english noise files are: noiseENU.txt & noiseENG.txt

Hope this helps someone.

SQL Server 2005 Fulltext Search Problem

The first code same reads 'find a row where a value matching 'Name123 AND LegalForm123' in either Col1 or Col2'. It's giving the right result.

You probably want

CONTAINSTABLE(ServiceProvider, (Col1, Col2), 'Name123', 1000) 
    or CONTAINSTABLE(ServiceProvider, (Col1, Col2), 'LegalForm123', 1000) 

Using full-text search with PDF files in SQL Server 2005

Thanks Ivan. Managed to eventually get this working by starting everything from scratch. It seems like the order in which things are done makes a big difference, and the advice given on the linked blog to to turn off the 'load_os_resources' setting after loading the iFilter probably isn't the best option, as this will cause the iFilter to not be loaded when the SQL Server is restarted.

If I recall correctly, the sequence of steps that eventually worked for me was as follows:

1. Ensure that the table does not have an index already (and if so, delete it)
2. Install Adobe iFilter
3. Execute the command exec sp_fulltext_service 'load_os_resources', 1;
4. Execute the command exec sp_fulltext_service 'verify_signature', 0;
5. Restart SQL Server
6. Verify PDF iFilter is installed
7. Create full-text index on table
8. Do full re-index

Although this did the trick, I'm quite sure I performed these steps a few times before it eventually started working properly.

Error while configuring Sql server 2005 for full text search

Solution:
I got the problem, I used to login using sql authentication.
One has to login using windows authentication, to have the required permissions.

Its gonna be a problem, I guess, when I configure the sql server 2005 for full text search of my hosting provider. Because the only way I have access to that database is via sql authentication.

Fulltext search (sql server 2005) works only on some fields

Just trying to figure out what's going on: what do you get with this query here?

SELECT * FROM static WHERE FREETEXT(*, N'str')

If you're not explicitly specifying any column to search in - does it give you the expected results?

Another point: I think you have a wrong language ID in your statement. According to SQL Server Books Online:

When specified as a string,
language_term corresponds to the alias
column value in the syslanguages
system table. The string must be
enclosed in single quotation marks, as
in 'language_term'. When specified
as an integer, language_term is the
actual LCID that identifies the
language.

and from what I found on the internet searching around, the LCID for Greek is 1032 - not 19. Can you try with 1032 instead of 19? Does that make a difference?

Marc

---

Related Topics