Hi everybody, Does any body know how we can customize the behavior of Microsoft Indexing Service (i.e. Infosoft.dll). I have the following case: I am currently in the process of adding full linguistic support to a an unsupported MS-Search language. I need to index certain characters i...more >>

Hi, I have set up an Active Directory, Certificate Services on Windows 2003 Server. I am running SQL 2000 Server. AD and Certificate Services were installed correctly. My goal is to be able to use SSL when connecting to SQL Server via Query Analyzer. I also want to keep the SQL Server insta...more >>

Hi NG, can anybody tell me how to edit the fill word list? I have problems when searching e.g. for "0,4mm" or strings like "13-556-124" over MS SQL Server full text search. In these cases SQL Server gives me unsatisfying search results. I think that this problem refers to the fill word li...more >>

Hello, Something strange happens if I try and do the following: If I use the containstable function, with top_n_rank, along with an extra "and where" clause, then the top_n_rank does not seem to return the correct number of rows. Here is an example to explain my point: select *, tempid...more >>

When i query key words , i can get the docname,doctype etc. Can i get some texts near the searching words ? like the result fo google ! Does the MSSearch.Query offer one interface ? Does the IFilters(according the doc type) offer one interface to get some text from the doc? thanks ...more >>

Full-text indexing was manually set up to work on the development server. Now, I need to write a SQL script to programmatically set up Full-text indexing on the staging server and then on the production server. The SQL script must be rerunnable. It should handle the scenario where full-tex...more >>

Hi all, I spent the best part of the day yesterday scouring this newsgroup, carrying out the routines that are common with FT not populating (checking local system account, checking empty HCR reg entries for empties, making sure local system in sys admin group) but none of them seemed to solv...more >>

Given the query: Select * from A left outer join B on A.bid=B.id left outer join C on A.cid=C.id Where contains(A.*, ‘word’) or contains (B.*, ‘word’) or contains (C.*, ‘word’) I am concerned about performance – does SQL Server retrieve every row from A (which might eventually contain a ...more >>

Hi, I have set up an Active Directory, Certificate Services on Windows 2003 Server. I am running SQL 2000 Server. AD and Certificate Services were installed correctly. My goal is to be able to use SSL when connecting to SQL Server via Query Analyzer. I also want to keep the SQL Server insta...more >>

Hi I have a 1.5 million row table with a text field. Can anybody think of a way to remove any duplicate rows where the text field contains the same data (and a way which will not take days to run!) For example if I have two rows with "SQL SERVER IS GREAT", I want to remove one of them. ...more >>

Hi, I have a table setup running full-text index in sql server 2000. After finishing 12 hrs long of initial full population, I immediately turned on the "change tracking, update index in background". The full text index population restart all over again even though there is no data change a...more >>

How difficult is it to implement the full text searching capability provided by SQL server if it wasn't implemented to start with? Currently I have an application that allows searching based on user profile fields. However it's not taking advantage of the full text indexing. How much code ch...more >>

I configure a table with FT index , but when i search the table , nothing returned , why ? Windows 2003 EE (Chinese Edition) SQL Server 2k + SP3 (Chinese Edition) 1. makefile C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\Config\noise.chs 2. start the MSSearch service with...more >>

When searching for this street using this parameter: 'L''Avenue De La Reine Elizabeth' I get a result ( The record contains 'L''Avenue De La Reine Elizabeth The Second',) but When I try searching for the whole thing, it won't return any rows, nor will it for 'L''Avenue De La Reine Eli...more >>

I've been digging around trying to find out how to allow my FTS implementation deal with punctuation and "special" characters in a way that fits my needs, but can't find a definite answer. I'm leaning towards trying to switch to the Neutral Word Breaker setting to see if it will fix it, but ...more >>

I just ran into an example where the user put 8117 characters in the text box and the text was truncated to 8000. This is just straight text and we want to be able to Full-Text index this field. What is the best way to deal with this? I was sure 8000 characters would be enough. Most are onl...more >>

Hello, I have full text search enabled on two large tables, the first one has 3 million records (FT index column length is around 512-1025 char), and the other one has around 1.6 records (FT index column length is around 50-120 char) The simplest query that uses the smiplest form of FT o...more >>

After full population on a table with 1 million rows: Item Count: 0 Catalog size: 1 MB Unique Key Count: 1 I used SQL Enterprise Wizard for Full-Text Indexing on a table with 1 million rows. Obviously, Item Count should be greater than zero. SQL Service is running on Local System acc...more >>

How do I use FREETEXTTABLE on two columns in a table but rank by only one column. For example I have two columns News_Summary,News_Content In this case the user can specify during search if he wants to search News_Summary or the News_Content or Both.There also other columns in the tables...more >>

I have a Text field in my database that has data along with the HTML tags. I dont want to search these HTML tags on my FUll text Search. Example Data < Font color='red'> Blah</Font> I want to ignore the font tages on my search. How do i do it? ...more >>

Hello, Is there a way to make it possible to search for the following searchstring with containstable? "test AND is" what i mean is that it will ignore the word "is" but will continu searching for "test" thnx in advance, Marius...more >>

Hi, I was wondering if anyone could point me in the right direction with a problem I'm having moving a full-text catalog from one server to another. In a nutshell, I want to take a database with full-text indexing enabled and move it and the catalog to a new server. The existing system is...more >>

For some reason I cannot get these new noise words to be taken into account. I have stopped the Microsoft Search service, edited the noise.enu file, started the service again, and created a new index on my table. Unfortunately, none of the noise words I have added have taken effect. Pl...more >>

I'm having a problem with character accentuation in SQL Server 2000. The database was created with SQL_Latin1_General_CP850_CI_AI Collation and table varchar fields are using the same collation. The problem happens when I use characters with accentuation, database is not saving the correct ...more >>

Hi Is there a system query that will tell me the number of rows in a given catalog? Cheers James ...more >>

I am eargerly awaiting my MSDN Universal, until then I am very interested to know if Yukon will allow a View to be FT Indexed ? I am working on a scenario right as we speak that may be worth pushing off for the moment if SQL 2005 Will support these Anyone ? Or do I just need to jump through...more >>

We're looking at rewriting part of one of our applications and FINALLY moving from SQL 7.0 to SQL 2000. One reason we haven't is currently the table we index has 3 columns we want to be able to do a FT search against and since SP3 on SQL 7, MS has "changed" the rules. So, our current solu...more >>

When I start a full population on a full_text catalog manually (Right click on a full_text catalog and click start full_text population), it works perfectly. But when I try to schedule a full pupulation on the same catalog, it seems like it never start to do the full population. Do I need to...more >>

The Windows SharePoint Services (WSS) API has a method SearchDocuments in the SPWeb class. This method accepts a search string and eventually executes a SQL Server stored procedure that calls the FREETEXTTABLE function to do the full text search. It seems to me that CONTAINSTABLE is a more rob...more >>

I have a solutions database I am adding Full Text Search to. Unfortunately, a huge part of the "solutions" resides on a shared lan in the form of attachments. I've used FTS before, and I've used Index server before (though never on files located remotely) Are there any resources on using bo...more >>

Hi I'm dealing with a company that have 3 web servers a test, staging and live. All these servers are sql server 2000 and are situated offsite. I do not have dirrect access to them, I have to send them email with scripts when things need changing. The website works on the test and the stagi...more >>

Hi Is there a system query that tells me which columns are a fulltext index for a particular catalog? Cheers James ...more >>

I have a solutions database that I'm setting up Full text search on. Part of the "solutions" is a huge folder of attachments on the lan. I've done both FTS alone and also Index server alone. Are there any whitepapers or good websites that talk about combining the two? I'd like to conduct ...more >>

I was told by a programmer that the full text searching on ms sql is only a good solution on static data, meaning no new data is being added frequently, as the indexes have to be rebuilt each time someone is added/removed. I will be running a bulletin board system, so there will be many new pos...more >>

I've been testing using a full text index on a few columns in one of my databases, and I'm having trouble with the index appearing to miss records. I have stopped all updates on my database, and done a full population of the SearchTitle field in my STK table. I have then waited until the full tex...more >>

We're about to deploy a new application, based primarily on FTS. Because it is an isolated use, I'd like to take advantage of the FTS features in Yukon. Is Yukon stable enough to go into a limited production environment? I understand that there is at least one more beta release to go. We'd...more >>

We just moved a system to a new cluster and we can't build a full-text index on a table. The crawl seed <MSSQL75://SQLServer/2116e6df> in project <SQLServer SQL0001200005> cannot be accessed. Error: 8007007f - The specified procedure could not be found. . Search KB articles indicates that...more >>

Hi, I am connecting to SQL Server 2000 on a Windows NT machine, remotely via a client on a Windows XP Pro machine. Although Full text search service is running on the server, I cannot access it on my client machine. It appears greyed out on the windows XP machine. Besides, I have scheduled it f...more >>

I have a bulletin board application (written by a programmer) and want to allow users to search the database for keywords/phrases. Doing a basic search eats up the cpu like crazy, and I know there are some strategies on how to get this done right. Can someone provide me with an overview of ho...more >>

Can anybody help me where i ca find like detailed SQL Server 2000 Framework (like for a companys documentation), like the whole outline of every component for SQL SERVER 2000?? please help thanks ...more >>

Yesterday I created a full text index on a single field in my database with 365000 rows in order to do some performance testing to see if moving to a full text index would provide significant improvement over LIKE clauses for looking up words in titles of products. I now need to create indexes on...more >>

Hi, I use FTI to search for records in my table. It has now come to my attention, that several users search for the brand name "B&O*", but that the search does not return the result intended. As far as i can tell, FTI treats the "&" sign like an AND - or something like that. It looks lik...more >>

Hi John (or indeed anyone who can answer my two questions!), After much playing, I'd removed all the weighting and partial matching from my FTS SQL statements, as it just wasn't producing the results I wanted. I've now got no options but to use it (new requirement) and it's gone back to drivin...more >>

When I create a full-text catalog in Enterprise Manager, the following error pops up "An unknown full-text failure (80077007e) occurred in function EnumCatalogs on full-text catalog". Any idea?...more >>

Since upgrading to service pack 3a (from sql server with no sp) I am experiencing performance issues with my full text searches. Its hard to quantify the problem - but since the upgrade I am definitely seeing significatnt increase in duration for searches - especially when they run concur...more >>

Hi, Can i know what's requirement in order to implement FTS? I mean Hardware and software requirement thanks ...more >>

Hi, I've got what I believe to be an unusual situation. One of our clients is reporting that they need to randomly restart the MSSearch service. They detect this need by noticing that recent data (anywhere from 5 minutes to 5 hours) is not being found when they performa a search. However...more >>

Is it possible in any way to control the NEAR operator so that it returns only records containing the search words within a certain distance - e.g within 3 words or 5 words or a paragraph etc.? Apparently the way the NEAR operator works is that it returns all (or almost all..) the records c...more >>

I'm using a Freetexttable search as in the following: SELECT blah from Table1 INNER JOIN (FREETEXTTABLE(Tabl1, keywords, ''' + @Query + ''') AS RANKTBL1 When a user types in xp for the query, it returns different results than XP in caps. Can someone explain this to me and is there a way...more >>

When populating a table with a column of TEXT datatype, an error message was shown, indicating that the data is too large for the specified buffer size. How we I change the buffer size from the SQL Server Enterprise Manager? TIA, Jeffrey...more >>