Are both SQL 7.0 and SQL 2000 on the SAME Win2K Server?
If so, then they are in fact using the same MSSearch engine as only the most
current copy of the "Microsoft Search" (mssearch.exe) is maintained. There
have been many changes, fixes and enhancements in SQL 2000 for FTS and to
get the SQL 2000 FTS queries to work correctly on HTML data, you will need
to put the data into a column defined with an IMAGE datatype and an
"extension" column (defined as sysname or char(3 or 4)) containing htm or
> I have a SQL 7.0 installation on Win2k and a SQL 2000 installation on
> The SQL 7.0 search works and the SQL 2000 search does not. Because both
> version of SQL Server are installed on Win2k, the infosoft.dll were the
> same. Substituting a NT 4.0 version of the infosoft.dll did not solve the
> We are considering using an image field in a future version of our
> application but the current version is required to work on SQL 2000.
> I compared infosoft.dll versions
> > Steve,
> > What OS do you have SQL Server 7.0 as well as your SQL Server 2000
> > on?
> > If your SQL 7.0 is installed on NT 4.0, I suspect you are seeing the
> > behavior. However, if your SQL 2000 is installed on Win2K, I suspect
> > seeing the incorrect behavior. If so, you've encountered a recently
> > bug on the Win2K wordbreaker (infosoft.dll). The issues is related to
> > punctuation that is "right next to", i.e., no space between the letter
> > the punctuation. In your case, the < and >. You can revert back to the
> > 4.0 behavior, via:
> > Stopping the "Microsoft Search" service.
> > Renaming the Win2K infosoft.dll to infosoft.old (or infosoft.w2k, in the
> > winnt\system32 dir)
> > Copying over the infosoft.dll from a NT 4.0 Server.
> > Re-boot the Win2K Server and run a Full Population.
> > BTW, your SQL Server 2000 is using the default full-text language of
> > that represents English_US (see SQL 2000 BOL title "default full-text
> > language Option" for more info.)
> > Also, if you're FT Indexing HTML meta tags in columns with char/varcar
> > TEXT datatypes on SQL Server 2000, you should consider porting this data
> > a column with an IMAGE datatype as the new FTS "Image Filtering" now
> > supports and understands HTML meta tags. See SQL 2000 BOL title
> > Supported File Types" for more info on this new feature!!
> > Regards,
> > John
> > > I've noticed a difference between SQL Server 7.0 and SQL Server 2000
> > > full-text search. In a text field that contains:
> > > ... <TITLE>Microsoft</TITLE> ...
> > > SQL Server 7.0 will but SQL Server 2000 will not return a result for
> > > following queries:
> > > select * from table where contains(text_field, 'Microsoft') or
> > > select * from table where contains(text_field, '"Microsoft"')
> > > My 'default full-text language' setting is for US english.
> > > exec sp_configure 'default full-text language'
> > > shows
> > > default full-text language 0 2147483647 1033
> > > 1033
> > > It appears that language neutral full-text is implicitly turned on for
> > > Server 2000 because adding the <TITLE> start and end tags to the
> > > string will return a result for SQL Server 2000.
> > > Steve