I would like to be able to search the metadata of files (e.g. Title, Keywords, etc) that I have stored in a database. I have included the "metainfo" column (image) in the full-text catalog. Running a freetexttable on the documents table returns matching results for web pages (.htm, .aspx), howe...more >>

Ihave an Active/Passive Cluster. Can someone point me to a Technet article or provide the steps for adding Full-text indexing? I can't seem to find one! Thank you. Jay ...more >>

I have a web application coded in dotnet and ms sql server. It is a multiuser system that lets members search for other members via their profile fields. It gets complicated in that it lets users search based on distance from a zip code, as well as degree of separation. However every time I ...more >>

Hi, I'm FTS newbee, and have some questions 1) check noise words inside stored procedure 2) @@Error fails 3) The best way to stop and restart indexing 1) Just found out that this error Server: Msg 7619, Level 16, State 1, Procedure usp_ft, Line 2 A clause of the query contained only ...more >>

I have create a Catalog and I am trying to find a record in the database that satisfies the term: 102/3 or 102-3 These two terms works exactly the same way. The SQL searches for records that have 102 or 3 in any position in the record, including in the middle of a word. I have concluded ...more >>

Hi All I have a database of students which contains a table StoredCvs. This contains all of their CVs (Resume's) and has a full text index stored in a "StoredFilesCatalog". It is unlikely that this table will grow to more than 1 million rows although it is possible. I now want to start stor...more >>

Hi, when i m searching with contains I want to ignore a character inside the keyword, Like Es(ignore next char)ref --> Es?ef will return the results Esxef , EsHef Estef Eskef also thanks for your help from now. -- Esref DURNA ...more >>

Hi, I read in MSDN that If the text and asterisk are not delimited by double quotation marks, as in CONTAINS (column, 'text*'), full-text search considers the asterisk as a character and will search for exact matches to text*. However.... I have this code: If chkOptions.Items(1).Sele...more >>

Hi. I have a question - does anyone know on what criteria is the rank set by FreeTextTable ? I created some records in the table "titles" containing the words "drink", "much" and "abstinence" and.... well.... I can find no rhyme or reason to the way this rank is established. I got the ranks 29...more >>

where can I find documentation on DBCC CALLFULLTEXT? I cant find any on the net. I am trying to find out if my index is set to auto populate. thanks!...more >>

Hello! I need to do a freetext-search on multiple columns in the same table, searching with the same keywords. For example WHERE FREETEXT({col1, col2}, "searching for this") I know that this can be accomplished through WHERE FREETEXT(col1, "searching for this") OR FREETEXT(c...more >>

How do I start the Search Service on my SQLServer 2000 on winxpsp2 ? I have installed it, but in the Service Manager I see only DTC OLAP SERVICE SQL Server SQL Server Agent I read that I should see an etry named "Search Service" in the Service Manager. In Enterprise Manager if I rig...more >>

The following query works perfectly (returning all words on a list called "Dolch" that do not contain a form of "doing"): SELECT 'Dolch' AS [List Name], dbo.Dolch.vchWord FROM dbo.Dolch LEFT OUTER JOIN dbo.CombinedLexicons ON CONTAINS(dbo.Dolch.vchWord, 'FORMSOF(INFLECTIONAL, "d...more >>

I have a simple FT query SELECT PK,TEXT_DATA FROM TABLE WHERE CONTAINSs(TEXT_DATA,'"search1" and "search2"') I get duplicates in the result set, despite the fact that no duplicates of the PK,TEXT_DATA exist in the table... Is this an indication that the FT index is corrupt ??? Any...more >>

Hi, Is there a way to ignore table locks when using the CONTAINSTABLE statement ? Here is a code sample : SELECT [KEY], RANK FROM CONTAINSTABLE(MyTable, *, 'MySearchTerm') as S, MyTable WITH(NOLOCK) WHERE MyTable.ID = S.[KEY] This query cannot return results when there is a lock on "MyT...more >>

I see a lot of these in my Event log on the SQL Server for my Windows Sharepoint Services site. It would be nice to know what files are not being indexed and why. Posting in the WSS group got me advice to update to SQL Server SP3 (done at install) and/or post here. Event Log Messages: One or...more >>

I am implementing a full text search. When I search for the word 'is', it is giving a wrong result. I need the help to solve this problem....more >>

Hi I am receiving the error "query contained only ignored words" from the word "best" that is not in the ignored words list. While researching the problem online I found the following link: http://www.dbforums.com/archive/index.php/t-965368.html In the post the poster states this is ...more >>

Hi, We are debating whether it is a good idea to store large documents (on the average over 100 MB - max size currently at 220 MB) in SQL server itself OR to strip the document of the "noise" words outside of sql server and store just the words we need to be indexed. We are concerned about t...more >>

I have a merge replication process that is having some major performance issues. The replication process seems to run just fine for about a half hour (200k records), and then it hits a brick wall. I continually get the message: "The process is running and is waiting for a response from one of t...more >>

Hi, Are the Ifilters COM/CORBA objects that I could call from my code? I'm trying to find out whether I could call them in my java code to extract text from various document formats such as PDF/MS Office etc before storing them to the database. The documents that we are looking for full text se...more >>

Hi I want to search all the tables and columns in a database for a specific piece of text Just need to do it in query analyser, can anyone help with the script, done a web search with no results dont care about performance as its a one off cheers mark...more >>

After upgrading to Windows 2003 Server full-text indexing has stopped response. I have created full-text catalog and have populated it but in EA the status of catalog remained "Population in progress". This status is not changing for a long time (I tried to wait for more than one day and it ...more >>

We're using sql server v 8.00.760 (SP3). We have imported resumes into a table and have full-text search working. What is the proper syntax to search for "c#" or ".NET"? Kyle! ...more >>

Hello, I've searched high and low for the answer to this, but to no avail yet...and I don't think it's possible...but does anyone know of any filters available for Microsoft Publisher (.pub) files or Web archive (.mht) files? We're in the process of implementing SharePoint Portal Server 2003 alo...more >>

Hi, I have FT indexing set up on an image column, the column is binded to a document type column and the FT indexing works fine. My problem is that when a html file has the following utf-8 metatag <META http-equiv=Content-Type content="text/html; charset=utf-16"> then the FT searches do not w...more >>

Hi, I have 2 database with same data and structure running on 2 different machine on sql2000 sp3. However, the full-text search come out with different result set. Any idea to fix the problem. Thank you in advance for all your help. James ...more >>

Which method is faster for full-text search One row big varchar field comment VARCHAR(1000) on lots of small varchar fieds like 10 rows comment VARCHAR(100) -- Message posted via http://www.sqlmonster.com...more >>

Hi, Does anyone have experience with Full Text catalogs on large tables? We have a full text catalog on a table with about 30 million rows. Acording to BOL, once you get over 1 million you'll need to make some adjustements. Our system works, but often we get the following errors with ad hoc...more >>

Hi! I have a query that takes about 3 seconds to process. When I add TOP 20 to reduce the number of hits the same query takes 18 seconds. Is this a correct behaviour? /Henke ...more >>

Hi All, We are using a FORMSOF(INFLECTIONAL) query and trying to establish why we get results returned for a search on "Luke" but no results for "Lukes"? Whereas "Rebuke" and "Rebukes" returns the same number of results. Is there a dictionary or similar that we can add to to ensure that pl...more >>

Hi, I'm trying to install MS SQL server 2000 full text search. I have two questions: 1) Many of the documents are scanned images wrapped as PDF files. Do I need to install Adobe IFilter to index these documents? 2) Some of these documents are 160MB in size. Would MS SQL server be able to...more >>

According to the Books Online information on full-text indexing, there are limits on the size of a file that can be indexed in an image column: 16MB filesize, 256 KB of filtered text. I've exceeded those limits in my testing (with Word docs), and still appear to be able to access information in ...more >>

Dear All, Firstly I know my question may be not perfectly fit in this newsgroup, but I hope I find some assistance or guidance, we have the customers data in different 3 systems (CRM,ERP, another Custom developed system) , we are now going to assign a unique customer id across all these ...more >>

Here's one that had me stumped for a good couple of hours. While working on my laptop, I was trying to rebuild a fulltext search catalog. I tried numerous times repopulating, deleting and rebuilding. whenever I tried to start it populating, I got messages in the event log saying the crawl had ...more >>

I am having a problem with SQL Server 2000 Developer Version and Microsoft Search on Windows XP. Microsoft Search did not appear in SQL Server Service Manager. I ran SQL Server 2000 setup and found that the Microsoft Search component was not installed so I installed it. I am not sure how that ...more >>

Hi, I'm building a search engine for a website using sql server 2000 (sp3). My development invironment is Windows XP Pro and the production server is Windows 2003, and I'm getting the same problem on both machines. I have two tables in the cataolg, one contaning only text fields (varchar a...more >>

We are using MSSearch via SQL Server to perform free-text searches. However, we would rather not store the entire raw text in the SQL Server. So is there a way to use the MSSearch service outside the context of SQL Server? In other words, to populate MSSearch directly with free-text, let it b...more >>

Hi I would like to search for "R-483" phase using SQL CONTAINS function : DECLARE @i_FreeText Varchar(255) SET @i_FreeText= '"r-483*"' SELECT TOP 10 * from iBlockFreeText where (@i_FreeText is null or contains(iBlockFreeText.Content, @i_FreeText)) , but it fails. It's oka...more >>

I've come across a Transact-SQL statement as follows: -- Statements start here select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from sysobjects where type = 'U' -- end here Questions: (1) How should the 'select' statement be interpreted? (2) What are the rules for u...more >>

Hi, I'm in the process of implementing a full text search service using MS SQL server 2000. Can anyone point me to some materials, books/websites that I could browse before I start my work? Appreciate your reply. Anantha **************************************************************...more >>

The spesific characters of turkish alphabets ->>iğüşöç couse problems while searching in the Fulltext search. The letter ı is "I" in the uppercase in our alphabet which is equal to the English letter "I" The the other lets does not exists in english alphabet. so the turkish letters alway...more >>

I am trying to use the full-text indexes with Sql Server 2005, and wanted to index pdf files. I have downloaded and installed the Adobe PDF iFilter from Adobe, and have tested it using the iFiltTst on a directory with PDF files. It does index the pdf files. I then moved the files into a sq...more >>

Plat form: Windows 2003 enterprise ed, SQL Server 2000 Failover Clustering SP3A enterprise ed. Action: How to change the default location for full-text indexing search by using TSQL/SEM on failover clusterng environment ? For SQL Server default installation, we have default the locations...more >>

I'm not sure that "sqlserver.fulltext" is the right group for this posting. I have a table with 3 unicode text columns, English, Hebrew, and Farsi respectively. I want to write a query where the WHERE clause does a "... like '%<searchtext>%'..." on each of those columns. Here's my problem:...more >>