Hello All, There is a stored procedure sp_fulltext_service which takes the property to be changed or reset and the value of the property as the parameters. sp_fulltext_service [ [@action=] 'action' [ , [ @value= ] value ] ] If value is NULL, sp_fulltext_service returns the current setting...more >>

Reading the MS article "10 Ways to Optimize SQL Server Full-Text Indexing" http://msdn2.microsoft.com/en-us/library/aa175787(sql.80).aspx It says regarding a full population: "MSSearch will issue sp_fulltext_getdata once for every row in your table. So if you have 50 million rows in you...more >>

We're using SQL Server 2005 service pack 1. It was my understanding that FreeTextTable automatically includes inflectional forms. We're not able to get any inflectional forms of words during the search (even if we use Contains with the special syntax). Are we missing something in the server...more >>

Still working on this query: select * from products inner join freetexttable(products,*,@searchstr) ft1 on ft1.[key] = products.p_id left join sku on sku.p_id= products.p_id inner join freetexttable(sku,*,@searchstr) ft2 on ft2.[key] = sku.sku I replaced the inner join with a ...more >>

Hello All. We are having a performance problem with our FTS (running on Sql Server 2000 Std vs a MS Commerce 2002 FP1 website. All running on Server 2003 OS. SQL and webserver are on different machines). Once the re-population is complete, the FTS runs fine. Each week, we add new items v...more >>

Hi All: Last month, I was looking for way to query 3 FT tables simultaneously. I found that a UNION with 3 separate queries worked, but someone pointed out that duplicates would occur (and they did). It was suggested that I use a query like: select <columns> from table1 in...more >>

Running SELECT productid,productname from productsFullText where freetext (*, 'x2000') or SELECT productid,productname from productsFullText where contains (*, 'x2000') gives 1 hit. SELECT productid,productname from productsFullText where productname like '%x2000%' gives 7 hi...more >>

Hi guys, I have been writing a search engine that uses FTI, and have read that you cannot use leading wildcards in your search clause (i.e. "*ome" would not return home, but "hom*" would return home). Just wondering if there is a solution to this problem while still using CONTAINSTABLE & FT...more >>

I'm not sure what I did generates the correct result...I think I got the information here but I don't remember as it was a few years ago. I edited the noise-ENU file and removed the letter C from the last line. Then I did rebuild on the indexes. It almost seems like it worked...but I have ...more >>

I just upgraded from msde to sql express and need a way to run my existing jobs. I tried sqlschedular but dont seem to get it to work. How can I access or run my existing jobs. Help is appreciated -- Message posted via http://www.sqlmonster.com ...more >>

I am running the below query and getting back results that have the word "mode" in it. Isn't the keyword CONTAINS supposed to treat my search expression as one word? Can someone show me what is wrong with this query so that it returns only records that have the exact search expression "mode-4"...more >>

Does the new text search method in SQL Server provide a “best match” text search? Does it work similar to a Google search, for example, where the most words that match gets the highest relevancy score, then these should appear first. I wondered if the new text search provided a accuracy/relev...more >>

Hi, I'm new to this group, i've a problem with the full text search with sql server 2000, I've been searching for a word (say "the") in the a full text indexed table for each column and i get the error as : "Run-time error '-2147217900(80040e14)': A clause of the query contained only ign...more >>

I have set up a full text search to handle multiple columns searching for chinese But the result of the search isn't really what i have expected. I have setup the catalog to have a chiense word break, and the columns in the tables are all nvachar when i do something like select * from ...more >>

Hello, I store text files into an SQL Express DB, in a varbinary field. I have change the naming of some columns in my indexed DB, and I have changed the indexed column: now, I have two varbinary(max) columns in my table, one is indexed but not the other. All my files are text. It appea...more >>

My sql below returns like 10,000 records and takes like 22 seconds. Is this normal or can I tune it to run faster. SELECT s.story_id, spec.title as title, s.title AS story_name, CONVERT(char(10), u.air_date, 101) AS rundown_date, '' AS video, '' AS cg_text,i.text AS item_text, i.type, i.con...more >>

I use fts to query a sql server 2005 db and the results are displayed on a web page. Out of a large text how can a summary be extracted "including" also my keywords? Like more contextual summary. google has a fancy way of formating the search results and display a keyword contextual descrip...more >>

We have a Full Text Index on 4 columns and it doesn’t return the results in the order we think it should in 2000 or 2005. In 2005 I created a persisted calculated column of these 4 columns and created the Full Text Index on it and I returned the results in the order I expected them. In my ...more >>

Hi, I need to move the file for my full-text catalog to a different drive due to space issues. I've tried the following: ALTER DATABASE mailarchivedec05 MODIFY FILE (NAME = MailArchiver3, filename = 'F:\FTDATA') But get an error: Server: Msg 5037, Level 16, State 1, Line 1 MODIFY ...more >>

I added full text indexing on the title field in a table but when i reference the same field in an embedded sql it says cannot use contain on a field that is not full text indexed. example SELECT top 400 s.story_id, u.title, s.title AS story_name, u.state, CONVERT(char(10), u.air_date, 101)...more >>

Hi, I am new to Transact SQL and am trying to concoct a full text search across multiple columns of a single table, and then replace the found text with a new string. Some of these ntext columns have multiple strings separated by 'special characters' (i.e. carriage return). This seems li...more >>

I am using full text on a colum of company names. My question is what is the best way to full text search names when a lot of them have apostraphes such as Dave's Hardware or Tony's Plumbing? Should I create a column that doesn't have apostraphe's using replace() and make that my full text ...more >>

I have an existing SQL 2000 Cluster setup and would like to add Full Text search to it. Is there any specific doc or best practices for this configuration? I have started the install once but the only option was to uninstall SQL Server. Do I run ftsetup.exe instead? ...more >>

I have a table in Sql Server 2000 with full text indexing setup on a column called 'contents' with a datatype of Text. The column contains HTML, and I want to search for a particular link eg. <a href="/hm/default.aspx?i=40559#secure"> ...by using the following phrase: /hm/default.aspx?...more >>

I am doing some prototyping using FTS in SQL 2005 Standard and am having serious problems getting searching to work when using IMAGE or VarBinary(max) fields. The index sortof works when using varchar fields. The only problem with varchar is that it doesn't seem to always auto popluate when ...more >>

i, like hundreds of other people, am unable to use the Full Text indexing feature because of the bug in SQL Server Enterprise Manager that disables the ability to configure it. See the Microsoft Knowledge Base article, but realize that it doesn't apply. http://support.microsoft.com/?kbid=270...more >>

Hi, I'm using SQL Server 2005. What's difference between mechanisms of "Manual" update and "Incremental" population? I also need some clarification about "Update" type of population. Thanks in advance, Leila ...more >>

I have been working with my DBA and have not yet found the issue. I have my development database on a SQL Server 2005 server. I enabled it for full-text catalogs and created a catalog with no issues whatsoever. When I go to create the index, however, I run through the wizard (using SMS) until ...more >>

I have to start by saying I'm new to FTS in SQL Server and could be doing something stupid. However, everything I've read so far contradicts what I'm seeing. Here's the issue; I setup an FTS index in the Adventureworks DB using the Address1 field in the Address table to query against some...more >>