Hi, I've enabled a full-text index on a table having 77 thousand records on a varchar(50) column. And yet when I when I populate the catalog: exec sp_fulltext_catalog 'OrdersCatalog', 'start_full' I get an item count, SELECT fulltextcatalogproperty('OrdersCatalog', 'ItemCoun...more >>

I have a large db and some large FT catalogs. When I try to delete ftcatalog I see msg: "Server can not obtain LOCKS ...." Why this message? Its my test-server and no any users. SQL Server used AWE and 5G from 8G. Thanks. ...more >>

In Yukon, if I do a fulltext search and also put let's say "userid = 5" in the where clause, for example, [Where contains("description","yukon") and userid = 5] Does Yukon search for all the "yukon" among all the datarows first or search for userid =5 first? Obviously search for userid = 5 fi...more >>

Hi, I'd like to implement incremental population for a given table. I don't understand if I need to use both "sp_fulltext_catalog" and = "sp_fulltext_table" to accomplish this task. BOL is a bit nebulous in = their explanation. "sp_fulltext_catalog" has an @action value of "start_incremen...more >>

Hi, I have a table which data is organized as follows, Style Color Size_Qty MEW6SQ215 101 XS,12; S,12; M,10; MZ10E727L 360 29,2;30,4;31,6;32,4;33,2; M002U2402 387 S,34; M,54; L,35;XL,17; M002D6502 100 XS,137; S,50...more >>

Hi all, I am getting this error when my query contains a word like "of": "A clause of the query contained only ignored words." The SQL statement uses the CONTAINS clause. This used to work fine on SQL Server 2000, but I recently switched to SQL Server 2003 and can't get it to work. I do...more >>

Hello All, Database size=150 GB FT indexed Table = 120 millions of records. On the start of project database was small and FT catalog builds successfully. Now building and populating can not finish. The status of FTC is: Populating in progress, may be paused, but not Idle. I see this 3 ...more >>

My understanding from full-text search (with SQL 2000) is that you can only search a table and not a view; i.e. you cannot create a full-text index for a view. 1) Is there a way to full-text search a view? 2) If not, what could I be using the search data in the database using a view which i...more >>

Hi, i'm a beginner in sql server 2000 and i have a question. i want to store word, excel, pdf etc documents in order to search them for specific content. i don't want to get as result lines of the documents but the names of them.What data type i must use? can i search and for Metadata informa...more >>

hi, it is really funny how ft search works: it seems to depend highly on what could be indexed, but it still doesn't follow a determined order. consider the following queries: select name from person where contains(name, 'hammer') select name from person where contains(name, '"hammer*"')...more >>

Hi, Can I create an Insert Into Query without sql server registration log? Thx. ...more >>

hello The situation is the following: I have table names "authors" with the columnes -- Message posted via http://www.sqlmonster.com...more >>

Hi, Is it possible to create a custom word breaker for SQLServer fulltext.... I use french word breaker, but for some specific tables, it's not exactly what I want... Seems such a dream will be feasible in SQL 2K5. Please anyone who knows, tell me the truth! :) Thanks, Sylvain H,...more >>

I want to create a report that shows dynamically created images from a web site. It looks like it will work OK, I can put the graphic in and a link http://localhost/image.aspx?123 but the image doiesnot show in the reports. I am guessing there is a miss match between the extension and the MIMET...more >>

If we restore a backup copy of a production db having FT catalogs onto a laptop running SQL Server Developer version, the restored db will contain references to FT catalogs whose underlying system files are not yet present on the laptop (because backup doesn't grab the FT system files). The index...more >>

HI!, Fulltext search is not working, i have two databases, fulltext search functionality was working fine on both of them till now. but suddenly fulltext search on one of the databases started giving out errors. when i try to populate, rebuild was giving out errors. when i said sp_full...more >>

I would be very grateful for advice or suggestions for the following problem. I have had no problem with Full Text Search in SQL2000 on my PC under XP Pro using the Developers Version of SQL 2000. However, I have created another copy of the same relatively small (100mb) database on a notebook...more >>

hello ng i've got a problem with my fulltext-index, or with the performance of the sql-server. in one database i've installed a fulltext-index. this index based on a often scheduled job, because it's nessessary to find the entrys directly after the insert. the schedule has a frequence of 1 mi...more >>

Running Windows Server 2003 Ent. x64 Edition on a quad Opteron server with 16G memory. SQL Server 2000 SP4. Total catalog files size ~2G . How do I optimize full-text search? Does OS do it by default? There does not seem to be HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Indexer in Re...more >>

I installed SQL 2000 on a Windows XP box with a typical install, but Full-Text Search does not appear to have been installed. It does not appear at all. I want to go back and install it, but the install wants to create a new instance. Can this be done without creating a new instance or un...more >>

Hiya All, We run a Developmnet-> Staging -> Production build environment here. We use Red Gate SQL Compare (a REALLY great bit of kit btw) to move between the tiers. We are having a bit of a problem now that we have some fulltext indexes defined. Reason being is that Development and Staging...more >>

Dear all, Another question: I would like to get an overview of how often a number of words, stored in a table KO, occur in a full text indexed column on another table. I can do this seperately: select * from names id | name ---+------ 1 | bush 2 | kerry select count(*) from texts ...more >>

Dear all, I am interested in using FTS for scientific investigation. Specifically, I need to know exactly how often certain keywords occur in documents in my collection. I know how many documents contain the keyword, but how do I find out how often the keyword occurs in these documents? I kno...more >>

Hi I'm working on a project where we intend to use Sql Server FTS to index pdf, chm, doc and html files. For performance reasons, we'd prefer to have the files stored on the file system as opposed to in BLOB fields. These files are going to be searched and retrieved by the general public vi...more >>

I have a table with a image column that contains documents like Word files and PDF files. I setup Full Text search successfully and I am able to search for a phrase though these documents, however, it does not seem to search through PDF files. I installed Adobe IFilter 6.0, still I have been u...more >>

Is anyone in this group using SQL Turbo? If there is, do you know what the 'Remove HTML' option really does? I'm using the MSSQL fulltext engine in an application that will be installed locally at a large number of locations(don't ask why...it's a government customer), and the population functio...more >>

Hi, My full text queries on a columns containing japanese text return strange results. - OS is Windows 2K Server (english) with Japanese support as default locale - SQL Server 2000 english with Japanese collation. I have created a full text index on a field making sure the language for wor...more >>

I have recently installed Full Text search component using the SQL 2000 Server CD, but still the Full Text Indexing option is disabled under Tools in SQL 2000 Enterprise manager. Also I don't get Full Text Search option under Support Services in Enterprise Manager. Although I am getting Micros...more >>

Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) I have a list of movie titles. If I do a search on "drive" I get all the titles that have that word (i.e....more >>

Hello, Is there a limit to the number of databases on a single SQL Server that can be Full-Text enabled? I have 15 databases all with Full-Text search working fine. Now I just made a 16th database and enabled Full-Text in the usuall manner and nothing seems to happen... When I check the Ful...more >>

Hi all, Here's part of a xml data field that we have in a text type column of a table: <TITLE>...</TITLE> <NAME>Mytech Works<NAME> <CUST>...</CUST> I am doing a search using a statement as follows: SELECT my_tbl.my_tbl_key FROM mytable AS my_tbl INNER JOIN CONTAINSTABLE (mytable, my_da...more >>

Hi, I want to setup a search that is capable of finding the correct records even if the search term was twisted. Given there's a lot of items in a database and the user is looking for a "10 inch wrench" he/she is probably typing "wrench 10 inch". Can full text help me with this issue? ...more >>

Hi all, How can I re-install the full text service? I can't create new catalog! I can't delete existing catalogs! I can't do anything involving the full text service, in Enterprise Manager or via Query Analyzer. Thanks in Advance, Fabio ...more >>

Hi all, How can I manually delete a fulltext catalog, via query analyzer? What is the command I can't delete it via enterprise manager! thanks in advance, Fabio ...more >>

im trying to insert some data from a form, on a asp webpage, to a database using a insert into statement, i keep getting a syntax error with the actual statment, ive been trying for a couple of days to debug it but no look all fields are text except, price which is currency any help is ap...more >>

I am tearing my hair out here! I have set up a full text catlog on an SQL 2000 Server ( Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 ), and everything seemed to go fine until I tried to populate it. It seems to get stuck in populate mode, and the only errors that...more >>