Full-text Index Search Not Returning Expected Results
Hello,
My full-text search isn't working at all! I have a temporary table with full-text indexing enabled where files are scanned for social security numbers. If it has one, the user will see a message that it believes it's found a SSN and won't upload it. There is only ever one row in this table, as we overwrite the contents upon each upload.
I'm testing this search, and it doesn't work. The table has the following columns:
attachemtId (int) - primary key
fileContent (image) - contents of the file
fileExtension (varchar) - extension of the file (this is always either ".pdf" or ".doc")
I created a .doc file that simply says "ssn", and then run the following query:
SELECT * FROM TempAttachment
WHERE CONTAINS(fileContent,'ssn')
and nothing is returned! I tried the same thing with a .pdf file, and same results.
I'm not sure if this is related, but earlier I had this issue where I had to reset permissions for the directory. I've tried removing the full-text index and adding it again, but that didn't do anything. I also checked error logs on the server, and there were no messages. Any help would be appreciated! Thank you!
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Full Text Search Is Not Returning Any Row
Hi I have installed SQL Server 2000 with SP4 on a Windows 2000 Server with Full Text Search component. I have created one Full Text catalog on three text columns of a table. But, when I am issuing a SELECT SQL with CONTAINS in SQL Query Analyzer, it is not returning any row. I am not getting any clue why Full text search is not working since it is not returning any error. Following is the SELECT command what I am issuing: SELECT * FROM postingdetails WHERE CONTAINS(pd_t_postingtitle,'web') The column, 'pd_t_postingtitle' contains the word 'web' in 4 records. Therefore it should return 4 rows. Instead, it is returing 0 rows. I hope some body must have faced a similar problem and can help me out. Regards Subrata
View Replies !
View Related
Save Indexed Search Words (Index Full-text Search)
We have SQL Sever 2005 and created a Full-text Search on a one of our main tables. When some one comes for the first time and searches for "carb" it takes a long time to return results, but when the same search is done within a few more minutes, results return in less than 1 second. Is there a setting in SQL Server 2005 to save all the indexes of searched words? Thanks
View Replies !
View Related
Sql Server 2005 Full Text Search Not Working As Expected On Production Server
I have this simple full text search query that works perfectly on my own computer using sql server 2005 express, however, on the production server(shared hosting)when I added the first 50+ rows, the full text search works perfect, but as the number of rows increases, the full text search can only see the first50+ rows, but not the new ones. Is there any quick solution for this or it's just a common mistake for developers for not properly indexed columns?Is there a way to re-indexed all rows without loosing data on the live server? search query: SELECT TOP 50 *FROM li_BookmarksWHERE FREETEXT(Keywords,@Keywords)
View Replies !
View Related
MS SQL Full-text Index Search
First of all I’m new to MS SQL, I did work with mySQL Table name db (real db has 12 columns) Id c1 c2 c3 1 tom john olga 2 tom john olga bleee I enabled full text index on all columns Problem when I do search like this: SELECT * FROM db WHERE CONTAINS(*,'�tom� AND “john�') It will return only one row (id 2) – I understand that the full text search does look only at one column at a time because it did not return row #1 Anyway I thought that I can add extra column c4 and when user enters new data it will save data from columns c1, c2, c3 to c4 (varchar(750)) and then I will do search only on c4 – this way it will work the way I want. 1) Is there any better way to do this? 2) How do I sort results by “rank� with SQL
View Replies !
View Related
No Results From Full-Text Search In SQL 2000
I built a catalog for a table. Ran the Full-Population, and having[color=blue]>5.000.000 items count, > 5.000 unique key count.[/color]However when I ran "SELECT * FROM Categories WHERE CONTAINS(*,'Met*')"I am getting zero results. 'Met*' appears in more than 1000 times intable Categories, but I also used many other keywords without anyresults also.No errors in Log, for buliding the Catalog, everything ran fine.Any Ideas???
View Replies !
View Related
Enhance Full-text Search Results
Hi, I'm using a full-text search over all available columns in target table and trying to enhance displayed results. Rank from CONTAINSTABLE is a start, but also it would be great to be able to find out some information about how the record was found, for example the column name (or a list.... with ranks?) containing search terms. Is there any way to do that? Thanks, Sergey.
View Replies !
View Related
Full Text Search Index Catalog
I have tried the full text search index catalog for searching text data. It seems to work reasonably fast for upto a 100,000 records but the performance fall considerably once you increase the database size to half a million records. Can any one suggest what measures should be taken to optimize the full text search index so that the retrieval speed can be acceptable, typically say less tha 15 to 20 seconds. Thanks
View Replies !
View Related
Full Text Search - Index Files
history.ix, index_a.ix, index_d_1.ix, index_di_1.ix, index_i_2.ix, index_k_2.ix, index_kl_1.ix, index_klh_2.ix, index_n.ix, index_r_l.ix, index_sv.ix, index_v.ix, index_v_ix.log, indexlog.dat. This files are generated durin full text search. now i have doubts regarding this, 1) Can we referrence this files directly 2) Where it will be located in our system? 3) is it loaded for each Full Text Index we created for the table. 4) How this file are used in Full Text Search.
View Replies !
View Related
Full Text Search Yields Wrong Results
Hello, When searching for ceratin terms the full text search in one of our SQL-Server 2000 SP4 databases yields wrong results. Here is an example: The following search-condition "containstable ( [table], [field], 'Maier' )" returns also results that contain 'Mai' or 'Mailand'. This, of course is wrong. When using the search term 'Mai' or 'Maie' the search works a expected. One interresting thing is that the search-condition '"Maier*"' also causes a "too many results" error. Why? What's going on here. I'm pretty clueless Thanks for any suggestions. sincerely Johannes
View Replies !
View Related
No Results Returned For Full Text Search On Varbinary(max) Column
Hi, I was wondering if any SQL Server gurus out there could help me...I have a table which contains text resources for my application. The text resources are multi-lingual so I've read that if I add a html language indicator meta tag e.g.<META NAME="MS.LOCALE" CONTENT="ES">and store the text in a varbinary column with a supporting Document Type column containing ".html" of varchar(5) then the full text index service should be intelligent about the language word breakers it applies when indexing the text. (I hope this is correct technique for best multi-lingual support in a single table?)However, when I come to query this data the results always return 0 rows (no errors are encountered). e.g.DECLARE @SearchWord nvarchar(256)SET @SearchWord = 'search' -- Yes, this word is definitely present in my resources.SELECT * FROM Resource WHERE CONTAINS(Document, @SearchWord)I'm a little puzzled as Full Text search is working fine on another table that employs an nvarchar column.Any pointers / suggestions would be greatly appreciated. Cheers,Gavin.
View Replies !
View Related
No Results Returned For Full Text Search On Varbinary(max) Column
Hi, I was wondering if any SQL Server gurus out there could help me... I have a table which contains text resources for my application. The text resources are multi-lingual so I've read that if I add a html language indicator meta tag e.g. <META NAME="MS.LOCALE" CONTENT="ES"> and store the text in a varbinary column with a supporting Document Type column containing ".html" of varchar(5) then the full text index service should be intelligent about the language word breakers it applies when indexing the text. (I hope this is correct technique for best multi-lingual support in a single table?) However, when I come to query this data the results always return 0 rows (no errors are encountered). e.g. DECLARE @SearchWord nvarchar(256) SET @SearchWord = 'search' -- Yes, this word is definitely present in my resources. SELECT * FROM Resource WHERE CONTAINS(Document, @SearchWord) I'm a little puzzled as Full Text search is working fine on another table that employs an nvarchar column. Any pointers / suggestions would be greatly appreciated. Cheers, Gavin.
View Replies !
View Related
Full-text Search Does Not Automatically Update Index When CHANGE_TRACKING AUTO
On Sql Server 2005 Standard if I insert a new row into SomeTable that has a full-text index: insert SomeTable(keywords)values('this is a test') and then query: SELECT * FROM Message WHERE Contains(keywords, ' "test" '); I get the expected rows all rows that have "test" in the keyword. On Sql Server 2005 Express new rows are not returned unless I rebuild the catalog. Is this a known limitation of Express? ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ CREATE TABLE [dbo].[SomeTable]( [key] [int] IDENTITY(1,1) NOT NULL, [keywords] [nvarchar](255) NOT NULL CONSTRAINT [PK_SomeTable] PRIMARY KEY CLUSTERED CREATE FULLTEXT CATALOG ft AS DEFAULT; CREATE FULLTEXT INDEX ON [dbo].[SomeTable] KEY INDEX [PK_SomeTable] ON [ft] WITH CHANGE_TRACKING AUTO ALTER FULLTEXT INDEX ON [dbo].[SomeTable] ADD ([keywords]) ALTER FULLTEXT INDEX ON [dbo].[SomeTable] ENABLE
View Replies !
View Related
Help W/ Stored Procedure? - Full-text Search: Search Query Of Normalized Data
Hi - I'm short of SQL experience and hacking my way through creating a simple search feature for a personal project. I would be very grateful if anyone could help me out with writing a stored procedure. Problem: I have two tables with three columns indexed for full-text search. So far I have been able to successfully execute the following query returning matching row ids: dbo.Search_Articles @searchText varchar(150) AS SELECT ArticleID FROM articles WHERE CONTAINS(Description, @searchText) OR CONTAINS(Title, @searchText) UNION SELECT ArticleID FROM article_pages WHERE CONTAINS(Text, @searchText); RETURN This returns the ArticleID for any articles or article_pages records where there is a text match. I ultimately need the stored procedure to return all columns from the articles table for matches and not just the StoryID. Seems like maybe I should try using some kind of JOIN on the result of the UNION above and the articles table? But I have so far been unable to figure out how to do this as I can't seem to declare a name for the result table of the UNION above. Perhaps there is another more eloquent solution? Thanks! Peter
View Replies !
View Related
Returning Closest Results When Search Term Doesn't Exist
I'd like to get some ideas for the following: I am writing a quick mini-application that searches for records in a database, which is easy enough. However, if the search term comes up empty, I need to return 10 records before the positon the search term would be in if it existed, and 10 records after. (Obviously the results are ordered on the search term column) So for example, if I am searching on "Microsoft", and it doesn't exist in my table, I need to return the 10 records that come before Microsoft alphabetically, and then the 10 that come after it. I have a SP that does this, but it is pretty messy and I'd like to see if anyone else had some ideas that might be better. Thanks!
View Replies !
View Related
Full-Text Search: Prefix / Suffix Search
Please help me to create an SQL Server 2000 Stored Procedure for using prefix and suffix terms. Example: Say I want to find "Terminator" (1984). I want to be able to use "Term" or "ator" as search results and still return the proper record. Here is my Stored Procedure creation sql: CREATE PROCEDURE sps_searchTitles(@searchTerm varchar(255)) AS SELECT * FROM Video WHERE FREETEXT (Video.*, '"*@searchTerm*"') GO --- The above does not appear to properly check both prefix ("Term---") and suffix ("---ator") terms. I am trying to accomplish what is similarly done with LIKE '%term%'. thanks, YM
View Replies !
View Related
Full Text Search- Substring Search Not Working
I have Sql server 2005 SP2. I enabled it for Full Text search. Substring search where i enter *word* doesn't return any row. I have a table testtable where description has word Extinguisher. If i run a query with *ting* it doesn't return any row. select * from testtable where contains(description,'"*xting*"') ; But it works if i do select * from testtable where contains(description,'"Exting*"') ; The Full text search document says it supports substring search. Is it an issue with sql server 2005?Please help.
View Replies !
View Related
SQL Server 2000 Full Text Search (extract Pieces Of Text)
Hello everyone ! I want to perform Full Text Search with SQL Server 2000. My documents (.doc, .xls, .txt, .pdf) are stored in a SQL Server field which is binary (the type of the column is image). I would like to know, how you can extract pieces of text from the documents. Example: I have a ASPX page with codebehind in C# making the search in a table in SQL server that is full text indexed. I make a search looking for the word "peace", than SQL server will take care about the search and return it to me the rows that match with that. But also I'd like to extract the 50 characters before and after where sql server found the word "peace" to show in the result page. Does anyone has any idea how to work around it ? Best regards. Yannick
View Replies !
View Related
Adding A Full Text Search Across Multiple Tables (with Text Fields)
Hi, i'm trying to do a full text search on my site to add a weighting score to my results. I have the following database structure: Documents: - DocumentID (int, PK) - Title (varchar) - Content (text) - CategoryID (int, FK) Categories: - CategoryID (int, PK) - CategoryName (varchar) I need to create a full text index which searches the Title, Content and CategoryName fields. I figured since i needed to search the CategoryName field i would create an indexed view. I tried to execute the following query: CREATE VIEW vw_DocumentsWITH SCHEMABINDING ASSELECT dbo.Documents.DocumentID, dbo.Documents.Title, dbo.Documents.[Content], dbo.Documents.CategoryID, dbo.Categories.CategoryNameFROM dbo.Categories INNER JOIN dbo.Documents ON dbo.Categories.CategoryID = dbo.Documents.CategoryID GOCREATE UNIQUE CLUSTERED INDEX vw_DocumentsIndexON vw_Documents(DocumentID) But this gave me the error: Cannot create index on view 'dbname.dbo.vw_Documents'. It contains text, ntext, image or xml columns. I tried converting the Content to a varchar(max) within my view but it still didn't like. Appreciate if someone can tell me how this can be done as surely what i'm trying to do is not ground breaking.
View Replies !
View Related
Problem With Full Index Search
I have implemented Full Text Search for my MSSQL Database and got stuck with this problem: When i try to search for the exact word 'Function 1' using the CONTAINS keyword, the query retrieving the following results too.... :confused: 1. Function 1 2. Function 2 3. Function 3 4. Function 4 Where i want the first answer alone. But it works good with the strings (ex: Broken Wire) where both are strings. :) Wont it work with the text which is a combination of a string and a number like 'Function 1' Kindly guide me!! SqlHunt
View Replies !
View Related
Clustered Index Vs. Full Text Index
Quick question about the primary purpose of Full Text Index vs. Clustered Index. The Full Text Index has the purpose of being accessible outside of the database so users can query the tables and columns it needs while being linked to other databases and tables within the SQL Server instance. Is the Full Text Index similar to the global variable in programming where the scope lies outside of the tables and database itself? I understand the clustered index is created for each table and most likely accessed within the user schema who have access to the database. Is this correct? I am kind of confused on why you would use full text index as opposed to clustered index. Thank you Goldmember
View Replies !
View Related
Full Text Search Vs LIKE Search
Are there any big differences between the two search techniques? It seems like they are both very similar. SELECT * FROM TABLE1 WHERE TEXTFIELD1 LIKE '%DATABASES%' SELECT * FROM TABLE1 WHERE CONTAINS (TEXTFIELD1 ,' "DATABASES" ')
View Replies !
View Related
Full-text Query (Freetexttable) Returning Duplicate Rows
We have a query that uses the Full-text index on a view that's returning duplicate rows. We thought maybe it was the way we were joining, but we were able to simplify the query as much as possible and it still happens. Here's the query: Code Snippet SELECT * FROM FREETEXTTABLE(vwSubtable, TitleSearch, 'Across five Aprils') AS KEY_TBL ORDER BY RANK DESC vwSubtable is an indexed view that contains some of the columns in our original table, and is also filtering out some rows from the main table in a where clause. There are no joins in the view. This seems like it's about as simple a query as we could get. It will return some rows twice (ie. the same primary key row is returned back as two separate rows in the resultset). This is a problem since we're filling a datagrid, which is throwing a ConcurrencyException because the primary key is already in there. I made sure we have SP2 installed on my SQL Server. Any ideas on what might be happening?
View Replies !
View Related
Full-Text Search
Hello ! With SQL Server Management Studio Express I have created a catalog and a index.Here is the code : create fulltext catalog myfirstcatalogcreate unique index myfirstindex on northwind.dbo.customers(companyname)create fulltext index on northwind.dbo.customers(companyname)key index myfirstindex ON myfirstcatalogWITH CHANGE_TRACKING AUTO With SQL Server Management Studio Express and the following command the full text search is working fine. select companynamefrom northwind.dbo.customerswhere contains(companyname, ' "blauer" ') I have a big problem : When I try to use this database (NOTRHWIND.MDF) into my .aspx file with VWD 2008 I get an error : Cannot use full-text search in user instance. Can you tell me what can I do to make use of full-text search inside my aspx pages ? Thank You !
View Replies !
View Related
Search Text Full
hi all.i want to search, for example :"test string" in database : table have column(name) , i want to search all rows with column(name) is "test " or "string" or "test string"i don't want to use(full text search of sqlserver 2005 ) can i help me.thanks in advance
View Replies !
View Related
Full Text Search Help
Hi I have a full text index on my product table. When I do a search for Record, it returns all values for Record and Records.Now If I do a search with a spelling mistake say Recod . it doen't return anything.How can I get the full text to return my query even if there is a spelling mistake ? Thanks My query:SELECT * From Product WHERE FREETEXT (description, @SearchString)
View Replies !
View Related
Full Text Search
I am asking about installing Microsoft Search service in SQL Server 2000 in Windows XP Professional Is that possible? And By the way it's not possible for me to switch to SQL Server 2005 that I know that full text indexing already exists in it thanks
View Replies !
View Related
Help With Full-text Search
MSSQL server database contains the projects table that allow full-textsearch.I search projects with name that contains exact phrase 'Project 2':SELECT * FROM projects WHERE CONTAINS(projects.name,N'("Project 2")'))but results contain projects with names "Project 1", "Project 2","Project 3"What is correct 2nd CONTAINS() function parameter for searching"Project 2" only?
View Replies !
View Related
Full Text Search
Hi everyone I am using SQL server 2000 with SP3 on Windows 2003 server. I have scheduled a job to populate a full text index incrementally. Everytime it runs the job to populate the index table it writes some messages into event log. Like this: 1. Event Type : Information Event Source : Microsoft Search Event Category: Gatherer Event ID : 3019 Date :8/7/2004 Time :2:21:00 PM User : N/A Computer : ARC-03-DEV Description:1 The crawl on project <SQL Server SQL00002000009> has started. 2. Event Type : Information Event Source : Microsoft Search Event Category: Gatherer Event ID : 3047 Date :8/7/2004 Time :2:21:00 PM User : N/A Computer : ARC-03-DEV Description: The end of the incremental crawl for project <SQL Server SQL00002000009> has been detected. The Gatherer successfully processed 998 documents totaling 0K. It failed to filter 0 documents. 998 documents were modified. 0 URLs could not be reached or were denied access. The event log is getting filled frequently. Is there any way to stop this messages? It is normal for Microsoft Search to write this message into EventLog? Even though there is no chanage in the database it give the above messages. Any one know the reason please help. Quick reply is appreaciated. Reagrda, Atiq Rahman
View Replies !
View Related
Full Text Search
Hi, We have a windows 2003 server (standalone) running SQL server 2000. We need to enable full text search on the database available in it. We have already added full text search in the installation and the option is available but when we try to create a full text catalog on any of the databases, it crashes ie., doesnot respond and gives the typical 'report to microsoft window'. We need to restart the SQL server after the same. can someone help us out. Thanks Smith
View Replies !
View Related
Full Text Search
Hi This is Yogesh Jangam I m using SQL Server 7.0 and ASP for an intranet application I am using Full Text Search feature os SQl 7.0. The problem is i am not sure where to populate my Catalog which i am using for searching Articles. Basically, Various writers will be submiting, approving Articles which can then be searched by other users to be read or referenced i was thinking to populate full or incremental, once an Article is approved, but i think it is time and resource consuming any way suggest me!!
View Replies !
View Related
SQL Full Text Search
Hi. We are having a problem with full text search. Our server has recently been down graded from enterpise to standard eddition SP3. I have reset the SQL Service account to local admin using enterpise manager but when i try to populate the full text catalogue I get an item count of 0. I have reregistered all dlls in the mssearchin directory and the language key in HKLMsoftwaremicorsoftsearch1.0eutral doesn't exist. Both the MSSearch and SQL services are running under the local admin account, and the builtadministrators account is a sysadmin. Any help will be much apreciated.. pulling my hair out on this one.
View Replies !
View Related
Full-Text-Search
Hi, I have a full-text search enabled table and an image data type column that stores the extracts from the documents stored in the files. I have created a full text catalog that indexes few columns in the table and image data type column as well and I assigned the extension column to this image data type column. Everything works fine except that search on the image data type column called, in my case "body" does not return anything. The documents exist, there is an information in the "body" column. My code goes like this: select FT_TBL.resourceID, FT_TBL.lang, FT_TBL.keywords, FT_TBL.description, FT_TBL.extension, b.rank from full_text_search as FT_TBL inner join containstable(full_text_search, *, 'Microsoft') as b on b.[key] = FT_TBL.resourceID order by b.rank desc any help appreciated, thanks
View Replies !
View Related
Full Text Search
hi, I just added Full text search in sql server 2000 installation. I tried to create a full text searh at employee table in the pubs database, at the final stage, IT froze on me. then when I checked the Window Task Manager Performance table, the mssearch.exe was taking 98% of the CPU. I had to reboot the server. then I installed teh fulltext search in another server box and get he same the same thing,but this time the cpu was a t 50%... Am I missing any steps that I need to do or configure sql server to be able to utilize a full text search.... Please advice.... Thanks Ali
View Replies !
View Related
Full Text Search
I am using a full text index search on SQL 2000 and need to rate the results by percentage. Can anyone give me any guidance on how to translate the search results into percentages? Thanks in advance--Mike
View Replies !
View Related
Full-text Search
Hi, I got a problem in my SQL2000 server full-text search function. When I created the full-text catalog and index on tables, I got the message showing it is successful. But when I checked the properties of the catalog, I found "item count" is zero. Apparently, it didn't populate any data into index. What could the possible reason be? Any idea? I appreciate your comments. Diego
View Replies !
View Related
Full-Text Search
I am trying to create a full text catalog for a database (using SQL Server 7.0 beta 3 eval copy). I am unable to create because of the error: "Could not load the full-text search component-SQLFTQRY.DLL" Does anyone know if there are limitations on the eval for full-text searching? I do not have the required .dll, possibily the install was not 100%?
View Replies !
View Related
Full-Text Search
I have enabled a table for Full-Text-Search and i´m looking for sample code (stored Procedures). The table contains Products like: Milk, Honey, Milk with honey, chocolate, nuts, chocolate with nuts, oranges, etc. the input comes from a webpage where users can search for products. How do i manage my stategy if a user puts only 1 letter or parts of words in the inputbox? thank you
View Replies !
View Related
SQL Full Text Search
Greetings ! Has anyone seen a problem in SQL 7 where you create a full text catalog, define an index on a table, and run 'populate', and end up with an empty catalog ? It runs for a while during the population, and there are no messages in the logs, but the 'item count' property of the catalog is 0. Also you can run a query that uses the index (i.e. uses 'CONTAINS') and you receive no error, and no results. I've set this up on other servers, so I know it works, but can find no mention of this problem anywhere. TIA Eric
View Replies !
View Related
Full Text Search
I am not having any luck setting up Full text search. I am using SQL 7 with sp2 on an NT server with service pack 6. I can set up the catalog with no problem but when I try to populate the catalog, I am getting the following error in the NT event viewer: One or more warnings or errors for Gatherer project <SQLServer SQL0000600005> logged to file <d:MSSQL7FTDATASQLServerGatherLogsSQL0000600005.2.g thr>. Unable to access crawl seed <MSSQL://LOCALHOST/6.341576255> in project <SQLServer SQL0000600005>. Error: 80072ee2 - The operation timed out. Unable to start crawl for project <SQLServer SQL0000600005>. No crawl seeds could be accessed. Detected end of crawl for project <SQLServer SQL0000600005>. Successfully processed 0 documents, 0K. Failed to filter 1 documents. Does anyone know how to correct this problem? Thanks Terry
View Replies !
View Related
Full Text Search
Hi, My Prod. server is having SQL Server 7.0 with SP2 installed. I am planning to install Full Text Search component. I know I have to run setup and select Full Text Search from Server Components. But, Do I have to re-install service pack 2 after this ? What are the other concerns in, such modifications to the existing SQL installation ? Thanks
View Replies !
View Related
Full-Text Search
Hi, When I am trying to start 'Full-text indexing wizrd', it is throwing me the error 'Full-text server service needs to be running in order to open this wizard'. But, I have Full-text search components installed along with My SQL Server 7.0 Ent. Edition and the 'Microsoft Search' service is running. Can anybody guess, what could be wrong?
View Replies !
View Related
FULL TEXT SEARCH
I have defined full-text indexing on a table a couple of months ago and the catalog was fully populated, it was working fine until now. But suddenly has stopped working, I have been scheduling incremental population on a regular basis and also have tried to remove and redefined full-text indexing but can't get it to work. Can anyone help please
View Replies !
View Related
FULL TEXT SEARCH
I have a table which is defined for full-text indexing and the catalog was fully populated, it was working fine at first, i checked it a couple of weeks after and doesn't seem to work. I have been scheduling incremental population on a regular basis, I have tried rebuilding the catalog and also have tried to remove and redefined full-text indexing but can't get it to work. Does anyone know what may be causing this to stop working? thanks in advanced
View Replies !
View Related
|
TRACKER
