1) The following query works fine and gives me the results I want. Is there a better more efficient way of writing this? DECLARE @SearchCriteria varchar(100) SET @SearchCriteria = ' "midler" ' SELECT Stock.OrderNo, Stock.Description, Stock.Category, Stock.s_Type, Stock.Manuf, Stock.Label, Ti...more >>

Hi, We just started getting this error when trying to create new catalogs on databases that do not already have a Full-Text catalog. I can create a new catalog on a database that has an existing catalog, but cannot on one that does not. I get the following error: "An unknown full-text failur...more >>

os : win2000 sql : sql2000 enterprise table name : job I created fulltext catalog table is job column name : title full population is every sunday am 5:00 incremental population is every 2hours from 7am to next day 3am whenever server is running the both population, cpu is full 100%(see...more >>

hello, I was wondering how to install server components on win XP Pro (above all FTS) Dring the MSSQL Enterprise eddition installation I got a message that my operating system doesn't support server components thanks in advance for any help ...more >>

I'm an FTS newb so please be gentle. When using most search services the results returned are accompanied by a snippet or excerpt of the full text that scored a hit showing the matched word(s)/phrase in context. For example, if I search for "full-text search" I might receive this as one...more >>

Hello, I'm running SQL Server 2000 on Windows 2000 Server. I created a full text catalog of a table and one column from the table. I'm getting unexpected results when I query the catalog. The table name is "doc" and the column name is docident. I store document identification numbers in the d...more >>

I appreciate your help but I need a bit of hand-holding here to get through this. I have a catalog created: MyCatalog With the following columns indexed from the respective tables... Hardware.m_Specs Stock.OrderNo Stock.Label Stock.Description Stock.Category Stock.s_Type Stock.Manuf Tit...more >>

I created a catalog and indexed 3 tables successfully, into that catalog. The catalog is 4MB in size, so there must be something in there. When I query the catalog with the following query, I get an empty column with (No column name) for a heading. SELECT FullTextCatalogProperty ('MyCatalog', 'm...more >>

Hello, At last I've found this group as I've been struggling with this by myself for some time now. I'm fairly new to this so I'm hopeing that this should be an easy thing for you guys to help with, so here goes... I have a SQL 2000 Server running the FTS on a Windows 2000 Server. I have cr...more >>

Hi, I've not used FT much, but I've successfully created a CONTAINSTABLE query on a database that contains names and addresses, using a wildcard for the field names. Can anyone please point me in the right direction for info on how to "weight" one field over another? For example - if someo...more >>

I had a fulltext index set up nicely on server 1. Searches returning correct results. Did a backup / restore to server 2. Dropped / Rebuilt the fulltext indexes. Now, the EXACT same phrases fail with the "ignored words" error. I can run the same exact sproc on server1, get perfect results....more >>

Hello, I have a Sharepoint installation and a SQL Server. Full text indexing is enabled - in Sharepoint and on the SQL Server. Using enterprise manager, I see the Full-text index, the tables/columns that will be indexed. I've rebuilt my full-text catalog and started a full population. ...more >>

I've read this has to do with IO conflicts, but does it really matter? I have a problem with a table with two text columns- it's only 80,000 rows but about 6 gb of text- the full text population takes forever (+3 days) and it's still going on. Also, the server's full text queries are really slow...more >>

We currently have an application that OCRs a tif image and places the recognized text in a SQL table. The table is then indexed by the FTS service. The app then allows you to search for any of the text and display the corresponding tif image in a viewer. I would also like to be able to search...more >>

Anyone know how to move the default FTdata location without manually editing the registry so that one doesn't have to use the PATH statement on every catalog created? TIA, Al...more >>

hi! I have a table who name is table0. its have a values like colum0: 01 colum1 : d01 and other table(this name is table1) have linked values to 01 and d01. I want to update d01 value in table1, look from table0. I have 32000-35000 value in table0 and table1.So how can I do it? Thanks,,,,,...more >>

Hi all, I'm making some experiments with the Full Text features offered by MS-SQLServer (MSSEARCH) and the Indexing Service. Querying MSSEARCH, I can limit the result using top_n_by_rank in CONTAINSTABLE / FREETEXTTABLE. I wasn't able to find out anything I can use to get the same result ...more >>

I need to assemble the smallest footprint possible of the code from the SQL Server 2000 installation disk that will install Full-Text Search on an existing instance of SQL. I have many instances where I need to add FTS to a laptop that already has SQL installed. Many users are remote and have...more >>

Hi, I have a column on a table that store urls. I want to index this column. But it seems that SQL Server is indexing the whole url and not each part of it (domain, querystring, etc). So if I have this url www.onedomain.com/somepage.aspx And I query 'onedomain' I want to get that url. However I'...more >>

I have used full-text indexing on some of my past jobs and just recently convinced my supervisor to try it out. I had forgotten that one can only index single column primary key tables. At my current work environment we have several identical databases on several servers. Those databases are being c...more >>

Hi, We have two SQL machine (Win2000+SP4, SQL2000+SP3). One of them is main production server, the second one is backup machine. We have big table there (34000000)and full-text index based on that table. We change this table everyday. Last week the changes were less than 30 records. On bot...more >>

I have added the full-text search option to an exitsting instance of SQL Server 2000 as I have done in the past for numerous machines. I created a new catalog on a single table with one text column to be indexed. The table is empty. I started full population after creating the catalog as I norm...more >>

We are having significant performance problems with full-text indexing on one column of a large database. System configuration: Windows 2000 Advanced Server with all service packs as of 6/10/04. We are using SQL 7 with all service packs as of 6/10/04. The CPU is a 2 GHz Athlon. The s...more >>

I am trying to delete all records from a table and could delete all but two of them. I noticed the two records have identical info. I am getting the following message: Key Column information is insufficient of incorrect. Too many rows were affected by update. Please help...more >>

Hi In the advanced full-text query of Transact-SQL searching, linguistic generation terms exist to give inflectional forms of nouns amd verbs eg WHERE CONTAINS(' FORMSOF (INFLECTIONAL, skate) ' ) This matches values that contain words such as "skate," "skates," "skated," and "skating." ...more >>

Hi, We have Full Text enabled for five languages, four of them are latin based and the other in Japanese. We have built catalogs by specifying the respective languages for word breakers. Now the inflectional search is working fine for the latin based languages but not working for Japanese...more >>

We are having problems with the ranking of search results being incorrect. The index is built on 1.6 million rows. An example of the issue is the user searches for three words 'cowboys hat dallas'. Searching for 'Cowboys' alone brings back 21 results, 'Dallas' alone 460 results and 'hat' alon...more >>

All - I have multiple databases with identical schemas on one Server. I want to be able to use FTS on each one independently. For example: DB1 - Table is PersonalInfo, Columns are FirstName and LastName DB2 - Table is PersonalInfo, Columns are FirstName and LastName This is the query I...more >>

Hi guys I'm trying to access an Indexing Service located on a remote machine usin the distributed query functionality of MS-SQLServer On a newsgroup on Goggle I found an old article in which it was describe a configuration that I replicated but with no lucky I have two Windows 2000 (SP4) box...more >>

When doing the following search (SearchAllProducts, keyword, 'FORMSOF (INFLECTIONAL, pens) and FORMSOF (INFLECTIONAL, pads)'), we get 170 records returned. But if we switch the and and replace it with an OR we get 1294 records returned. Whats the part we don't understand is that the OR is not pull...more >>

Hi guys, in the Full Text Retrieval documentation of MS SQLserver 2000 it's said that the document stored in IMAGE fields are "filtered" using the Microsoft provided filters (for these file extensions: .doc, .xls, .ppt, .txt and .htm) or third party filters (e.g. Adobe for .pdf). Little afte...more >>

When a database with fulltext indexes is restored to a different server, what are the appropriate steps to take, and in what order, to recreate the indexes on the new machine if it has a different directory structure than the original server? Should the indexes be removed and then recreated?...more >>