Not sure if this is the right group or not be I figured I would pose the question here to see if I could generate some feedback. Say I have a table (Employee) with one text column (Resume) that stores your employees Resume and another table (EmployeeJobs) with one text column (JobDescription) ...more >>

Hi I have a requiremnt for a Keyword search on 15 fileds on my tables. There are 4 tables - Each table has 3 fields of varchar. which needs to be idexed for full text. i.e Full text index on 4 tables, each table has index on 3 columns. Will there be any issues of this design? Please s...more >>

I had a fulltext index catalog created on a table with 1 column being indexed. I needed to add another column from the same table, so I added the new column to the catalog and restarted a full population again. I tried testing the new catalog, but the new column doesnt seem to be indexed. H...more >>

Hello, there is the chance to know "how near" one word is to another in the following query SELECT Description FROM Production.ProductDescription WHERE CONTAINS(Description, 'bike NEAR performance'); Moreover, could we control the proximity distance somewhat? We use sql2005 Thanks ...more >>

Hello, (Sorry for my English.) I am learning MS SQL Server 2005. I would like to use full-text search. I have installed: SQL Server 2005 Express Edition Advanced Services (SQLEXPR_ADV.EXE) SQL Server 2005 Express Edition Toolkit SP1 (SQLEXPR_TOOLKIT.EXE) The problem is that althoug...more >>

I have a table with all the support tickets of my clients, I need to know, whene was the first ticket of each user, I know distinct can do that, but I need the full row. I tried this: SELECT * FROM `MyCRM`.`ticket_history` a where Fecha = (SELECT MIN(b.Fecha) FROM `MyCRM`.`ticket_history` b ...more >>

I want to Index Tiff images by using Sql Server 2000. But i couldn't find any IFilter for indexing Tiff Images. Can anyone help? ...more >>

We recently created a table with an FTI in a database, then created a view to this table in another database. We found we were not able to access the FTI using CONTAINS through the view. We got round it by changing our SP to use the FQN instead of the view, but it was of interest that the ...more >>

I've been looking everywhere how to do this but all I find on google are articles about Sql 2000 FTS. I'm running SqlExpress 2005 Advanced edition. The Sql Server FullTextSearch Service (sqlexpress) is running. If I right-click my database, choose properties and then click on FILES, the ...more >>

Hi, I am experiencing a strange behavior in a full text search using the CONTAINS predicate. SELECT SomeField FROM SomeTable WHERE CONTAINS(SomeField, 'D-2001-286') The result is SomeField ---------------- D-2001-286 D-2002-286 The only explanation that could make some sense rega...more >>

Does anyone know what the differences are between the full version and the express slq server 2005 are? Or send a link to a site that might lead me in the proper direction. Thank you in advance. ...more >>

Hi, I am using SQL Server 2005 and have this error message when I try some queries using CONTAINS. Although I'm sure I installed fulltext, I get : SELECT FULLTEXTSERVICEPROPERTY('IsFulltextInstalled') : returns 0 and SELECT SERVERPROPERTY('IsFulltextInstalled') : returns 0 but SELE...more >>

Hi, 1) I've read timestamp isn't really convertible to datetime, but can a timestampfield tell me when a specific row was indexed, just to be sure adaptions where reflected in the index ... or does it only store whe a row was updated in order to let the system know it has to be indexed again? ...more >>

Hi, I am trying to customize SPS's search, it goes well with a little problem, My web part finds the documents that contains a specific word, But if my Search phrase is a noise word (for example "one", "and", "is", "there",......etc) it generates an exception. I tryed solve my proble...more >>

Hi everyone, I noticed that when I did an export on a database (lets call it DB_a) to another one (lets call it DB_b) it did not copy over the full text index (FTI) that was on DB_a. Is there anyway I can get the FTI from DB_a to be copied over to DB_b without having to rebuild the FTI on...more >>

Okay, I believe I am missing something crucial to fulltext searching. We are looking at ways to change a search from using "like" to "contains" in hopes of improving search performance on a table. We have a fulltext index on a lastname column. The current search is something like this: ...more >>

Hi, I have the following setup. Full population works fine on a table with 53 rows, unique pk etc. but when i turn change tracking and background index update on the FTI is not updated. Any thought are much appreciated! -THanks, Dave SELECT @@Version returns: Microsoft SQL Server 2000 - 8.0...more >>

Hi all. I have two tables setup for full text indexing. If full text catalogs where created and are being populated once a week fully and incrementally every day. Would full text still work if Full - Text Search Engine is stopped? Thanks ...more >>

re SQL Server 2000 I've read some info on John Kane's blog about different behaviour of the work-breaking DLLs for Win2K and Win2003 Server (and WinXP - ? not sure), and he gives the example of "AT&T". Is there some 'general' way of doing FTS for text expressions that include the & (ampers...more >>

Hi, I have a table ADSFULL containing ADVERTISMENTS with a FTI index on 2 fields FADS_TITLE and FADS_TEXT (see script at the end). -- The following query returns 94 rows. SELECT fads_title, fads_text FROM VWADS WHERE (ADS_ADID IN (SELECT FADS_ADID FROM ADSFULL WHERE (CONTAINS(*, '"tw...more >>

Hi, Does anybody knows how to create a T-SQL using CONTAINSTABLE from which brings an exact phrase results? At the moment I get the same results if I look for "Yellow*" and "Yellow"... is a bit weird. Thanks Jose. ...more >>

Hello everyone, I've got a little problem - wich drives me absolutely nuts by now . I'm trying to optimize my full-text search since a while now. Scenario: Full-Text Table: id - int - primary key - clustered srcID - varchar(30) srchField - varchar(150) - FULL-TEXT INDEXED src - varchar(1...more >>

Has anyone experience with SQL 2005 and the PDF filter 6.0 as is available on the Adobe web site?. My problem is that FT search for a PDF document does not work after installation of SQL 2005.- the filter works in SQL 2000. My Development environment Win/XP, SQL 2005 Dev, PDF iFilter 6.0. W...more >>

My full-text search works fine and it returns correct results, including records that contain the variation of the keywords. I bind the result to a gridview (ASP.NET 2.0), and programatically replace the matched keywords with a highlighted background etc. The problem is, my program only high...more >>

I have a stored procedure that is doing the following. =============================================== Select * From tblJobHeader WHERE CONTAINS(JobSummaryDescription, @KeyWords) =============================================== In my Asp.net application, I am passing in the following to the...more >>

When I attempt to add a new FullText Index in SQL2005. I get the following error. "Property Default Path is not available for FullTextService". I am trying to do this on my "Local" database and I get this error. I have done tons of Google research on this, and no one seems to be able to solv...more >>

thanks in advance! ...more >>

I'm appologize for posting this again, but I was told about posting aliases, seeing our company is an MSDN subscriber I set up the posting alias and I am reposting: We have a table with Full Text Index on a name column, running the following query returns different results than expected. ...more >>

We have a table with Full Text Index on a name column, running the following query returns different results than expected. select * from tablename where contains(membername, '"JOHN E SMITH"') Data returned is: JOHN E SMITH and JOHN L SMITH. Using wildcards return no data: select * from ...more >>

i run the following sql in sql server 2005 USE AdventureWorks; GO DECLARE @SearchWord varchar(30); SET @SearchWord ='instruction'; SELECT * FROM Production.Document WHERE freetext(Document, @SearchWord); it returns 7 rows results. but if replace 'freetext' with 'contains' it returns null...more >>

Hello! Is there a possibility to ignore white spaces using SQL Server 2005 full-text searching? E.g. searching for "JosephCool" should find "JosephCool" AND "Joseph Cool" (with white space) AND searching for "Joseph Cool" should also find both results. Thank you...more >>

i read an article: http://msdn2.microsoft.com/en-us/library/ms142541.aspx it mention process "Msftefd"(Microsoft Full-Text Engine Filter Daemon ) many times. but i never see it in my machine. why? sql server2005 +windows server2003. my FTS seems work fine. ...more >>

thans....more >>

Howdy, The following is quoted from book online: Instead of constructing a B-tree structure based on a value stored in a particular row, MSFTESQL builds an inverted, stacked, compressed index structure based on individual tokens from the text being indexed. What confused me i...more >>