Excellent! It was the extra skip row and some changes to the escape characters. Below is the actual format file that was successful!

10.0

6

1 SQLCHAR...

hi..

Are you both using SQL 2000 or SQL 2005? Can you provide more details?

Post the output of "SELECT @@version" or indicate what version of SQL Server you're using? If SQL...

There has been extensive debate (flame war levels) on this issue for many years, and as always the answer you seek "depends" upon what you are doing, and the size...

You can also go to my blog:

SQL Full Text Search Blog

http://jtkane.spaces.live.com/

for more info and links on SQL FTS, both SQL Server 2000 and SQL Server 2005. I will...

Keith,

Can I assume that the above sproc is used in a SQL Server 2005 FTS enabled database? How many rows in your Knowledgebase database? If so, then the following KB...

hi Rob,

Yes, many have succesfully used the 32-bit Adobe PDF IFilter using SQL 7.0, SQL 2000 and SQL 2005 on 32-bit WinXP and Win2003. Below is some SQL code that...

You're welcome, Bimal,

However, it seems you posted the SQL Server 2005 output twice. I need the SQL Server 2000 information to compare & contrast with the SQL 2005 FTS...

Bimal,

First of all, it is very uncommon for both T-SQL LIKE and SQL Full-text Search (FTS) to always return the same number of results as both search methods are different....

The informational messages about "No full-text supported languages found." is a bit misleading, but this message is informative "Default full-text index language is not a language supported by...

Certainly, unusual as with SQL Server 2005 developer edition SQL FTS is installed by default. I don't have an X64 box to test this on, but can you create and...

#1: You should use CONTAINS or CONTAINSTABLE and put the search word or search phrase in double quotes, for example:

select pub_id from pub_info where contains(pr_info,'"moon"')

will return only rows that contain "moon"...

Andrew,

Can you post the output of "SELECT @@version" or indicate what version of SQL Server you're using? If SQL 2000, then look in the server's Application Event log for "Microsoft...

No problem, SQL FTS is somewhat of a "black box" for diagnosing these types of issues. Yes, I was somewhat suprised by the initial "300" problem in finding that text,...

Hi Pat,

First of all, you can use a vairable (your @DESCRIP_PARAMETER) with both CONTAINSTABLE and FREETEXTTABLE. However, with FREETEXT or FREETEXTTABLE the words in the variable are treated as a...

Chris,

Your first query [select * from employees where freetext(employees.*,' "John Smith" ')] is a "phrase" search for the specific string "John Smith". Does this...