I can use fulltext remotely from my Sql Server Enterprise Manager remotely at work from my XP to my Sql Server 2003 at my office. If I right-click on my table at work, fulltext is there. If I try to connect from home, Sql Server Enterprise Manager shows me everything except that the fulltext ...more >>

Hi, This question is for all group, but particulary to Hillary Cotter, in relation to one article published in msdn (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro04/html/sp04f9.asp). Hillary, in this article, you explain that the new Full-text search engine, i...more >>

I am trying to set up a search query for users that just put in words with no "AND"s or "OR"s. I am curious if it is better to put "AND"s or "OR"s in places where the user doesn't specifically specify it. For example: I have a database with Jobs. If a person is looking for IT jobs and ...more >>

Hi, I need to search a product catalog for an online store, users must be able to search for kitchens with "4" burners, but I get this error : "A clause of the query contained only ignored words", below is the code for stored procedure I'm using. Before I send the "@SearchTerms" parameter, on ...more >>

How can I test from Windows, using the registry or APIs or ... that Full-Text Search is installed on a SQL box? I want to confirm during an application install that FTS is present. I want to perform the test at the operating system level, not through SQL Server. The application is installed on ...more >>

I'm trying to understand the benefit of using an FTS Inverted Index in the context of the following example: Given a set of articles, I want to retrieve a subset that matches certain keywords. I text parse and extract each word (excluding noise words) from each article (using space as the d...more >>

I've been using FTS for 5 years now on 1.5million rows of data. Certain things have alway annoyed me about it however: 1. I never managed to succesfully move/copy ft catalogs. 2. Noise words/symbols/single characters e.g. c#, c#, "I am not". 3. Search speed and ranking/relevance quality. 3. ...more >>

Hi, I have a test development database with a single table, which contains over 2 million rows. To check performance of fulltext vs index query, I enabled FullText on the database. The fulltext index runs for few hours, after that event viewer throws lots of (around 500) error messages (all...more >>

Can someone tell me which is better to say in QA: Use Database Go EXEC sp_fulltext_catalog 'catalog_1', 'Rebuild' EXEC sp_fulltext_catalog 'catalog_2', 'Rebuild' EXEC sp_fulltext_catalog 'catalog_1', 'start_full' EXEC sp_fulltext_catalog 'catalog_2', 'start_full' Or to say Use Database ...more >>

I have built a functioning full text search tool on my companies extranet site. I use the containstable function. I was curious what the syntax or process would be to do a "without these words" box to allow users to filter their search results better. Thanks, Daniel Hirsch ...more >>

Is there a way to specify which column weights more when doing full text search.. For example, I have three column, filename, description and data. I did full text index on all three column, but want to list the hits in filename first, is there a way to do it sql 2005? --Xin Chen ...more >>

I am new to full text search and researching on implementing FTS on failrly complex XML documents with HTML elements embedded into it. Is it possible to achieve this in a fairly working manner? If so what do i need to do. FYI - XML documents stored as image daatatype Navin ...more >>

I've got SQL2000 Enterprise edition running on windows 2000 advanced server, we've recently upgraded from SQL sp2 to sp3a, this caused a catalog rebuild but full population is taking forever. The column with Full text search enabled is of image type, there are 2.5 million record in the table, ...more >>

I am trying to do the following query select * from privateSearchFT where contains (*,'"formsof(inflectional,produce)" OR "formsof(inflectional,produce)"',language 1033) The problem is that it found no result although (*,'"formsof(inflectional,produce)"',language 1033) found some results. ...more >>

I have a database where the full-text catalogs can be manually populated (full or incremental) and searching against the catalogs are fine. However, whenever a table is updated, the changes are not being applied to the appropriate catalog. We have bounced MSSearch, SQL Server agent, SQL Se...more >>

Hi, I get the error message: "Unknown full-text failure (8007007e) occurred in function EnumCatalogs on full-text catalog" when trying to create a new full-text catalog in SQL Server 2000 Developer SP3 (on XP Pro SP2). The same database under SQL Server Personal (on Windows 2000) works without ...more >>

I have 2 full text catalogs, and one of them (sometimes both) goes to pause status occasionally. I suspect this occurs during a backup. I checked the status of the Microsoft search service and it states that it is "started", but I've found that restarting the service unpauses the catalog. Thi...more >>

Why do I get the error: System.Data.SqlClient.SqlException: Syntax error occurred near 'clerk'. Expected ''''' in search condition 'Benefits clerk'. I get this from: .... contains(jobdescription,'Benefits clear') Thanks, Tom ...more >>

Hi, Could you help me modify the SELECT statement below that would accomplish my final goal. SELECT col1, col2 FROM table1 WHERE col3 < @V In col1 rows have many duplicates col2 has unique values col3 can have 5 possible values: 5, 10, 15, 20, 25 Variable @V can be equal to 5 or 10 or 15 o...more >>

Will Yukon provide a transactional fulltext index ? In other words, will it be possible to do the following steps: 1. Begin a transaction 2. Insert a row into a table which has a fulltext index 3. (do not commit yet) 4. Perform a Fulltext query on the table which should find the row which ...more >>

It has happened several times...but we've just started tracking this. Yesterday and today I tried to do a fulltext search and server came back with an error telling me that fulltext search isn't enabled for the database I run sp_fulltext_database 'enable', then it starts working again. ...more >>

Hello I m not quite sure if this is the right place for my problem. But let me explain what I would like to have and what I really get. 1. What I want: - A table contains (TITEL) entries like: "lawyers at court", "human rights", "law", "public law", ... - I search for "law" and I get ...more >>

I have a need to allow my web users to search for things like "error 6" or "error 8". Currently, I use the full text indexing, and for the most part it works very well for my application. I have edited the noise words files for both noise.eng, noise.enu, and noise.dat and removed the numbers...more >>

Much obliged if anyone could help.. We're having issues with people searching with strings such as ["telecoms" and "at&t"] where the database refuses the second term due to the ampersand character. We've switched to a language neutral setting, but this doesn't seem to have helped -is there a w...more >>

I am writing a simple ASP.NET page that gives user's a text field to type in their search string. I want to know if there's some basic search string converter that can take my search string and convert it into a search string I can just drop directly into a select statement. I don't want to...more >>

Hi I'm having some problems structuring my query to execute with relevant results. Basically I have 1 table that has been FT indexed. The table has a CountryName, GroupName and ItemName. A user may enter a query as 'India houshold expenditure'. India is in the CountryName column and h...more >>

I would like some assistance if anyone has seen this before. We have just upgraded the server hardware that our SQL Server 2000 resided on. Previously we were running SQL Server 2000 SP2 on a Win2K Server platform. Now we have beefed our hardware and also we are running SQL Server 2000 SP3 o...more >>

Is there a way to do a google style search in SQL. For example if I have a search field and someone puts in: safe car It will automatically search like this contains(*,'"safe*" AND "car*"') Or if they put in "safe car" it would search in SQL like contains(*,'"safe car"') Or if ...more >>

Dear guys, knowing this is probably an old question, but how to search documents (doc, xls, ppt...) that are stored in image field type? Thank you very much, Joe ...more >>

Hello, i am fairly new to the world of SQL Server. ive spent many years working on ORACLE, but am now getting my feet into SS. I have a project right now, an online catalog, for a client. One of the features of the site is, as usual, a product search. I made a PROD_SEARCH table, consisting o...more >>

I have the following query: SELECT Distinct DatePosted,p.DateUpdated,Applied = Case when Email is NULL then ' ' else '*' end,p.PositionID,JobTitle,JobDescription = substring(JobDescription,1,200),Posted = replace(convert(varchar,p.DatePosted,6), ' ',''),lastUpdated = replace(convert(varch...more >>

I am having trouble Enabling Full-Text search for SQL 2000 Personal Edition. I have installed the Microsoft Search service and it is running. When I look in enterprise manager the Full-Text Search option does not appear in the Support Services folder. How can I accomplish this?...more >>

Helo, I am lookin for a way to use thesaurus feature in sql server 2000. all i managed to find is that it is done using the file C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\Config\tseng.xml And that is does not fully supported. but : how do I get it to work ? and does...more >>