Hi Since I have never had a good search methods I am looking for some reading material/source code to know what is achievable relatively easily Thank you for your suggestions, Samuel ...more >>

Hi, is it possible to return detailed information about fulltext searc results, like linenumbers ? I'm fairly new to using the fulltext search funtionality. I have bee playing around with it for a few days now. Does anyone know if this i possible ? Thanks, Mayce -- Maycel Kolla ----...more >>

Hi out there, could anyone explain? System: WinServer 2003 German SQL Server 2003 SQL query on fulltext field which contains revision no. e.g. 10.02.0512 After setting the LCID to neutral (0) by SQL statement I got better results than querying unter LCID German (1031). But one problem...more >>

Hello, I have a fulltext indexed column which contains some like: Section 0 Name Section 1 Name When I run a query like: select * from tbl_FullTextData where contains(name,'"section 0"') It returns records, but when I run: select * from tbl_Schemenamesearch where contains(name...more >>

Hi, I have the problem that if I search for certain phrases in SQL 2005 such as "voice over", it returns no results. I am using the following syntax: declare @criteria varchar(100) select @Criteria = N'("voice*") AND ("over*")' SELECT CategoryID, category, keywords FROM tblCategory ...more >>

Making accent insensitive searches with Full Text Search Installing an accent insensitive version of Microsoft Search Service It is really a shame that Microsoft did not provide a free solution for doing accent insensitive Full Text Searches (FTS) to customers who purchased SQL Server 2000....more >>

Making accent insensitive searches with Full Text Search Installing an accent insensitive version of Microsoft Search Service It is really a shame that Microsoft did not provide a free solution for doing accent insensitive Full Text Searches (FTS) short after the release of SQL Server 2000. ...more >>

Hi all, I'm a bit lost in my Full_Text_Search_Adventure: I've got a PDF-document in a SQL2005 table in which the following line resides: .... homer is a computer geek ... I'm querying the following statement: SELECT [fieldname] FROM [table] WHERE CONTAINS([indexed_fieldn...more >>

Hi.. SQL 2K issue. My client wishes to FTS for certain noise chars only, e.g. % which of course isn't in the noise word files. The best I've been able to come up with to resolve this is to escape the characters when I enter the string into CONTAINSTABLE, however the results return as if the quer...more >>

Hello, We're looking into the option of using dotLucene/seekafile server to do the fulltext searching on a sql2000 database, but haven't really seen dotLucene used directly with sql2000. Does anyone know if it is possible to use Lucene/Seekafile server directly with files stored in the dat...more >>

Forgive me if this has already been asked, but I need to be able to search either with accent sensitivity *or* insensitivity, depending on user settings or locale. Is there any way to set up my indexing (either in 2000 or 2005) so that I can choose during the search itself whether or not to be...more >>

What is the query syntax when querying the full text indexer to obtain the list of words indexed and their corresponding counts? ...more >>

Hi, Should I build a full-text index on a field before or after I create a non-clustered index on that field. Or does it matter? Al. ...more >>

Hello, I'm trying to figure out how to eliminate deadlocks in the system. It looks like one process involved in deadlock is process that populates FT index. The second process - is replication procedure that updates that ft-indexed table (tab1). At the moment FT is setup with change t...more >>

Hi, I've seen this addressed with regards to CONTAINS searches, and the kludgy work-around of using a seperate CONTAINS statement for each NOT condition. However, I have not seen this addressed using the CONTAINSTABLE query. My fear is that it will require a similar kludge, requiring eith...more >>

How to include more than 1 table in the full-text indexing catalog in EM using Tools -> Full-Text Indexing wizard ? ...more >>

MSIDXS driver is by default installed in Windows or do I need to download from MS site ? ...more >>

Hi, I would like to store some document like doc, pdf in a blob field, do I need any other field to aid the FTS on this field like an extra field to indicate the type of the document ? Or do I just include this BLOB field in the full index table ? ...more >>

What is the differences between: EXEC sp_fulltext_catalog 'Cat1', 'start_full' EXEC sp_fulltext_table 'Table1','start_full' if "Table1" is a full-text indexed in catalog "Cat1". Do I need to execute both SP? ...more >>

What SP can be used to schedule an incremental population ? ...more >>

I don't understand how to store the documents like pdf, rtf in these columns? Don't they stored as BLOB ? ...more >>

Can Full-Text searching be running on Win2K Professional ? ...more >>

This is from the web: >>> 5. If a full-text catalog population or query fails, check that there is no mismatch of user account information between the MSSQLServer and MSSearch services. Change the password for the MSSQLServer service using the SQL Server Enterprise Manager (do not use Ser...more >>

I've a 4 CPU server with Windows 2003 as OS and SQL 2000, SP3a and it performs very good. The SQL in configured to use AWE memory - 5 GByte - and to use all available CPUs on the machine. Moreover the MSSEARCH is configured to use at least 1 GByte RAM (CacheSizeMin and Max), according to a...more >>

These are getting from Full-Text Search Publisher.doc downloaded from MS website, >> Verify that the account used by SQL Server has the following permissions: Log On Locally Log On as a Batch Access this computer from the Network Log on as service ...more >>

Can Microsoft Search service installed on Windows XP professional with no SP ? ...more >>

I have a windows user account in SQL Server 2000 would like to use it to start MSSQLServer service and create a catalog in EM. But the status is always idle after several attempts of full population, how do I make it work? ...more >>

This is from the gatherer log after I started a full population: - The gatherer has started - The initialization has completed - Started Full crawl - MSSAL75://SQLServer/75d7831f Add Error fetching URL, (800700e9 - No process is on the other end of the pipe) - Completed Full crawl Any idea ...more >>

Hi everyone, Hope that you can help me wit this one. Can a particular field in a DB have a full-text index on it and a non-clustered index? Any comments/suggestions/user-experiences much appreciated. Al. ...more >>