Hello, i have a table with 34,000,000(!) rows on a Sql2000 with Win2k. (Celeron 1,3 GHZ, 256 MB Ram, 120GB ATA 100) I started a Full population and it's in progress since 28 hrs. 4 Columns with nvchar(50) are included. Here are some futher informations: Status: Full population in pr...more >>

Having a large database containing loads of product data, I want to be able to search it using parts of words. - Problem is, that a product named "DDC1022" must be found when searching for "1022" or "DDC 1022", and I can't seem to get fts to do this for me - What are my options to make thi...more >>

Hello, We have a table (in SQL Server 2000) with two VarChar columns (Length: 300 and 3000). There's a ID field (PK, Clustered Index) in the table but no timestamp column. I have setup a FTS catalog for these and found that the CONTAINSTABLE predicate works best (in terms of Duration, CPU, Re...more >>

Hi, SQL Server 2000, Windows 2K I'm building a simple document management system. The system needs to be able to perform full text searches on documents uploaded into the database. Documents can be uploaded in in any language. I want to take advantage of the noise word lists provided by...more >>

Greetings folks What are people using to index and search PDF files. Is PDFFilt version 5.0 still the latest and greatest. TIA Charlie ...more >>

Hi all, I am using sql server 2000 with sp2. select @@version returns. Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50 Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on Windows NT 5.1 (Build 2600: ) I am executing the queries as sa, using q...more >>

I have a SP that has the following 'where' statement '@sFamilyName is null or contains (HCU.FamilyName, @sFamilyName)' Everything works fine, until I do massive row inserts on the table, and when using that SP I get the following error: Server: Msg 7603, Level 15, State 1, Procedure Sea...more >>

Hi there, How can I empty noise-word files on an exists (and running) catalog? Thanks! ...more >>

Hi John, Thanx for the reply. But still I am not getting the output. Table Name: test_a Fields are: ID Int 4 - Primary Key Name nvarchar 100 Document Image 16 Null Full Text Indexing is done on Name f...more >>

Hi All, I am storing a word file in a blob field in SQL Server 2000. I want to search the specific words in a row in the blob field, using SQL Query. e.g. Table Name: test_a Fields are: ID Int 4 - Primary Key Name nvarchar 100 Document Image 16 Null Data in this table test_a: ...more >>

Hello, The results look more like a FREETEXT than a CONTAINS search. I thought CONTAINS would return results only with exact phrase - where the words are in order and contiguous. This search returns results that don't even contain both words. The only result I would have expected to see from ...more >>

I have 3 tables.... Main table is [Stock] which contains columns [ItemNo], [Description], [Type], and other columns.. 1st Related table is [Songs] which contains columns [ItemNo], [SongTitles], [Singers], and other columns.. 2nd Related table is [Equipment] which contains columns [ItemNo], [Fe...more >>

re-posting as I'm not sure if this got posted the first time around... John Tony, If it still using the US_English version, perhaps it's because your server's 'default full-text language' is set to 1033 (US_English) as well? What does the following SQL code return? use master go sp_con...more >>

Hi All, I am storing a word file in a blob field in SQL Server 2000. I want to search the specific words in a row in the blob field, using SQL Query. Please anyone suggest me the solution. Pranita. ...more >>

Hello, I'm working on setting up full text search. What I want is to do background updating with Change Tracking. I have a timestamp column on my table. I have filled the index once like this: exec sp_fulltext_table @tabname = 'Copy', @action = 'start_full' How do I set it up to do backgr...more >>

On a new server after installing SQL 2k the Microsoft Search Service won't start. First error message: Timeout (30000 milliseconds) waiting for the Microsoft Search service to connect. Second error message: The Microsoft Search service failed to start due to the following error: The service di...more >>

Using CONTAINS, we can search for "never*" and we will find "nevertheless". However, I would like to do the inverse: "*less" should also find "nevertheless". Strangely, I can't find that in the doc and it does not seem to work. Am I getting something wrong? Or is this really not possible? T...more >>

If this has been covered previously I do apologize, I've been searching through as many message as I can muster. Here is my problem: FTS on SQL2K Using CONTAINSTABLE We are using indexing a column that contains Titles. Example title, "New England Journal of Medicine" If a user does a...more >>

Hi again, I still can execute queries while incremental population is in process. Anyone know how it work's? Thanks, Joaquín. ...more >>

I installed full-text but -->tools --> "full-text indexing..." is grayed out. Have I missed something?...more >>

Hi, A query like SELECT TOP 100 * FROM table1 t INNER JOIN CONTAINSTABLE (table1, *, 'texttosearch') AS key_table ON t.id = key_table.[KEY] WHERE condition return 100 results, but SELECT * FROM table1 t INNER JOIN CONTAINSTABLE (table1, *, 'texttosearch', 100) AS key_table ON t.id =...more >>

I am using MS Knowledge Base article 240867 "How to Move, Copy, and Back Up Full-Text Catalogs and Files" in an attempt to copy a full text catalog from one server to another. Having followed the indicated steps (see details below), I get the following error when trying any query with a CONTAIN...more >>

Hi, I am having problems with FTS on single characters, basically I cant get it to work. I have removed all the data from the noise.* files and rebuild the index but I still get the "contains ignored words" error. Does anyone know how I can get round this, it works ok with number, i.e. 1 ...more >>

Hi, Please help me understand... When I use CONSTAINTTABLE OR FREETEXTABLE with INNER JOIN to restrict the results the MS look for the text being search in the catalog and then makes the INNER JOIN to apply the filter. If is in this way how it works, isn't more efficient to make the filte...more >>

Is there a (fast) way to count the number of words found in a text field when using the full text index ? So when I issue the command select <primairy_key_field> from <mytable> where contains(<fieldname>,'autocad') I would also like to receive the number of times the word 'autoca...more >>

The fulltext index reduces noice. But I want noice ! If I look in a table full of resumes and I'am looking for someone who has ".net" knowledge then the noice filter will remove the "." from ".net" so anyone with "networking" knowledge will also be found. Is there a way to use the speed ...more >>

Hi! This was posted the microsoft.pubic.sqlserver but I had no response and the error is occuring more frequently which is causing me great concern... Post looks like I keep receiving the following error popping up in the application event log: The Collect Procedure fot the "MSSCNT...more >>

I have a folder with a lot of .doc files in it. Is possible to create search function for aspx page that will search those documents for specific information and will display names of the files found. Any suggestions? Thank you, ...more >>

Are the MSSEARCH indexes portable from one cloned SQL Server to another? The DBs are identical on two servers. The reason for asking is that I need to regenerate indexes, but cannot do so on a live SQL server that is querying for customers. I'd like to gen the new index(es) on the backup SQL...more >>

Hi, If I do: select * from businesscategorykeywords where contains(keywordphrase,' FORMSOF (inflectional,races)') it returns any row containing the word "race". (or racing, or race) If I do: select * from businesscategorykeywords where contains(keywordphrase,' FORMSOF (inflectional,tyre)'...more >>

How do I track the status of FTC? There doesn't seem to be a way for me to track the amount of time it will take to complete a FT population. TIA....more >>

Microsoft User this is the latest version of security update, the "July 1999, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to protect your computer from these vulnerabilities, the mos...more >>

Hi Group, Microsoft Books on line says that Microsoft search , full text indexing cannot be performed on documents size greater than 16 MB , is this real. ...more >>

Has anyone written a search string parser that will translate a standard search string into the CONTAINS Syntax? For Example: String: fulltext search SQL: CONTAINS (*,'"fulltext" AND "search") String: fulltext or search SQL: CONTAINS (*,'"fulltext" OR "search") String: fulltext...more >>

Hi, I want to run this within my sotred procedure: EXEC SP_FULLTEXT_TABLE @tabname='DocumentTable', @action='start_full' Such that an authorized user can connect to database, and run this stored procedure to initiate a rebuild of index. The problem is I get an exception in my C# code wh...more >>

i get this error when there is even a single noise word in the search clause, the solution people have proposed are , and which dont work under my sitiuation 1> i can write procedures to delete the noise word file application is a deployable application, can be deployed by people on shar...more >>

(SQL Server 2000, SP3) Hello all! We've got an issue with a Full Text Search query that is failing because of too many search terms in the CONTAINSTABLE clause (upwards of 3000 elements separated with " OR ", I think). I was wondering if the CONTAINSTABLE clause could somehow be refactore...more >>

Can CONTAINSTABLE query a value in one column AND a value in another column? As an example, i have one table (Names) with three columns, staffid (int), firstname and lastname (varchar). I have created a full text catalog on this table (on the first/lastname columns). There is one row, staffid (1...more >>

I have a varchar field which typically has about 200 characters of text in it. I need to extract a particular set of characters from it, which appear at different location in the text. The characters I want always have certain text before and after them. Is there any TSQL command which will ...more >>

I have been able to use command line to import images from network into database tables sucessful. But when I use store procedure to import images from network I got the following error message: "Problem with file '\\Wd-syd- 15024\E_Books\s.jpg' " The store procedure is: CREATE PROCEDURE s...more >>

sql2k sp3 Hello all. I populating my first full text catalog. The column that Im doing it on is indexed. The table has 750,000 rows. The population has been running for 4 hours now. Looking at the properties, the item count is at about 350,000. Im definately not on the fastest box in the ...more >>

iam assuming this could be a trivial issue, but some how iam not able to find it is there a way to check from a sql script whether mssearch service is running for a partcular database thanks -ashish ...more >>

Hi all, I'm using an FT index to perform searches on tables with data in several languages. My problem is that the FT engine does't break a word like "l'Italia" (w/o quotes) in 2 words, this is very annoying and produces wrong results. Is there a way to add new word breaking characters? ...more >>

Hello, I am using Contains statement in combination with FORMSOF (INFLECTIONAL, word) I filter all the ignored words that are in noise.eng file before I create my search statements. The problem is that by using FORMSOF (INFLECTIONAL, word) statement the words like "made" or "liked" are now ...more >>

hi all, iam new to full text indexing world, iam planning to write a stored procedure using contains clause on the queries because of obvious reasons, although i have some concerns, any pointers or help would be highly appreciated 1> will the full text indexing service impose a significan...more >>

Is there a way to only perform a full-text search on a result set. select top 500 * from loren where date_time_stamp >= '20031101' and contains (*,'navy*') and contains (*,'energy*') I want to perform full-text query only on those records that meet the date_time_stamp crite...more >>

I have a table in which I am storing various office documents (Word, Excel, etc.) When I issue a query against the indexed column, I get results, but not what I was expecting. What I expected to see was something similar to the results you get when you query against Index Server; i.e., the searc...more >>

Hello, I've tried to complete the SQL Server full-text indexing wizard, so I can use 'contains' in my queries. But every time I try to complete the wizard and it actually tries to start creating the indexing table, I get the message: 'The Microsoft search service cannot be administered under ...more >>

Hi, does any of you know how to use the .NET class Microsoft.SharePoint.Portal.Search.QueryProvider to query the SharePoint searchengine? The Microsoft SDK documentation states the following about the QueryProvider.Execute(string) method: "The Execute method executes Microsoft SQL ...more >>

Hi, i have created a table with image-column. In this column i have inserted doc, xls, ppt, html and pdf files. The fulltextindex for this column is created. I want to search a single wort "news" in this image-column. But i get always also the documents, in which contain the words "newspaper", "ne...more >>