We are having problems with Full-Text searching... Recently we installed a SQL application that needs to access full-text searching. It gave the following error: "The crawl seed <MSSQL75://SQLServer/0539c240> in project <SQLServer SQL0001400006> cannot be accessed. Error: 8007052e - Log...more >>

Is that normal?? I am populating my catalog, and i see the catalog size growing 45MB, 47MB, 52MB..1MB and suddenly it goes to zero and starts again Is that normal?? thanks Alberto ...more >>

Hi I'm trying to improve a crawl's performance. Online books refers to changing the default batch size from 1600 to a number associated with the number of processors on my server. For the life of me, I have no idea how to go about changing the batch size for full-text search. Any and a...more >>

this is a new windows 2003 server/sql server 2000 set up (2-3 days old). full text is set up and working and definetely added data, andi have update index in background set. It seems to have worked for a while, then stopped. The application event log records events for Microsoft Search as 'Sea...more >>

Hi, I am running sql 2000 sp 3a on a ms cluster with w2k sp3. this below error occurs suddenly from aug 8th, which in turns the sql full-text will failed. 800706be - The remote procedure call failed. Server event log records: Microsoft Search service terminated unexpectedly....more >>

I have a fulltext index on the "INSUMOS" table with the following options: 1) Default language is spanish 2) The NOISE.ESN is empty (i.e. index everything) 3) The catalog is updated If I run the following query I don't get the expected results: select Nombre from insumos where CONTAINS(I...more >>

This is an old one, but I haven't been able to fix this just yet. We have a Win2k SP4 server which runs SQL server 2000 with the latest service packs and updates and everything. The server is a webserver that's being hosted at a hosting provider. There's absolutely nothing special or exotic ...more >>

When I look at properties for FT in cluster administrator the only owner I see is the node1 owner. Why doesn't owner node2 show up as a selection? I'm thinking about doing the following below from a MS KB article to fix my problem, any ideas? --------------------------------------------------...more >>

configuration hardware: cpu 4*1.5G RAM 2G software: windows 2000 server,sql server 2000 data: records >40 million ,spaceused > 14G fulltext variables: Number of items:>10 million,Number of Keys >1 million ,spaceused of Catalogue >500MB Note:the type of the column indexed is ntext. the cont...more >>

Hi We are running full text search with 4GB RAM on SQL server 2000. Ihave the /3G option on in boot.ini. The VM setting is set at 2048 to 4095. I read it in the manual that the optimal configuration for full text search is 1. The virtual memory size to at least 3 times the physical m...more >>

Hi All! I just want to know, is there any procedure to remove SQL Server full text from a cluster enviroment? My provider ask me to do that but i want an official document from MS about how to do it or if it is not possible. Thanks for the help. ...more >>

I am looking for "ABOUT" and i get this error Server: Msg 7619, Level 16, State 1, Line 1 Execution of a full-text operation failed. A clause of the query contained only ignored words. how can i get around this error? How can I exclude "about" from the reserved word, sinde is the name of ...more >>

What would be an efficient way to check for the integrity of a FT catalog or index in SQL 2000? Beside monitoring the event logs, I'm planning to write a script to parse out a string of text from a text column of a random row from a table has FT indexes, then go back and do a FT search on that...more >>

MSSQL 2000 sp3a, on Windows 2003. I will use examples from BOL. I am searching with a CONTAINS like this: WHERE CONTAINS(ProductName, ' "sasquatch ale" OR "steeleye stout" ') and am receiving results like 'sasquatch's ale' and 'steeleye's stout'. Plurals. Strange. I have performed a full po...more >>

Does anyone have a list of all punctuation marks ignored by the full-text indexing service by default. Noise files (i.e. noise.dat) only explicitly list the dollar sign ($) and the underscore (_) as noise "words". And another observation - the Windows implementation of MS Search (compared t...more >>

Hi all, I have 2 questions 1.- How can i search for "%" using like select * from table where sfield like '%%%' is not working! 2.- I am using Full-text catalog in one table of my db, i would like to know if i can search for % using CONTAINSTABLE(TABLE..... thanks Alberto ...more >>

How to generate full-texting setting script for porting to another SQL Server? ...more >>

Is missing.. Any suggestions ...more >>

I just setup my server with win2k3 sp1 and ALL the latest patches, plus sql 2004 standard sp4. I keep getting this error on a table with 39000 records where I am running a basic wildcard CONTAINS fulltext query for "cer*" Server: Msg 7643, Level 16, State 1, Line 1 Your search generated too...more >>

I am trying to improve searching performance ... but I am storing data that contains punctuation marks ... such as "E.L.O." and "R.E.M." (names of song artists/groups). Does this mean that I cannot use full-text searching at all for searching for these artist names??? Is there a work-breaker...more >>

How to run Microsoft full-text Search service on a separate machine(otherthanSQLServer) Is it possible to create Microsoft Search Service for full-text search on separate machine instead of running it on SQL Server machine? If so, how? Can you point me to any best practice to architect it? I ...more >>

Hello all, I have an application that grew to 1.5 million records and saw poor performance for a variety of reasons, but one huge 'doh' reason was that I didn't think to pre-allocate the database and the poor database file was fragmented as it grew from its default size in increments When we m...more >>

Anyone know how to get the context of the search results in a full text query? I'm trying to get similar results to the popular seach engines where it displays the link to the document, and underneath it it shows the context of the search words in the context of the document. For example, se...more >>

It seems that several people have had similar issues, but so far I haven't really seen an answer to this. It seems that using weights is not affecting the ranking the way I would expect. For example, if I search containstable(address, address,' ISABOUT(Circle WEIGHT(0.2), Lake WEIGHT(0.8) ) '...more >>

Hi there, I'm implemeting a full text search on my company's site and am trying to get around the 'Query contained only noise words' error. What's the best way of stripping the text from the search string and then notifying the user that the words were removed? (kind of like a google search...more >>

I have one table with 300,000 records and 30 columns. For example columns are ID, COMPANY, PhONE, NOTES ... ------------------------------------------------- ID - nvarchar length-9 COMPANY - nvarchar length-30 NOTES - nvarchar length-250 --------------------------------------------------- S...more >>

Hello friends i need to extract the content before its gets uploaded to a BLOB Field in my database. Now I tried using OFFICE XP PIA'S. but due to license issues and other technical difficulties and other reasons, i had to abandon that idea, Now i have to use IFilters and I cant get any idea as ...more >>

Hi there, I have SQL Server SP3 (DEV Ed) Installed on my machine. Select @@Version: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2) I have popped in th...more >>

Hi All I have several SQL Server 2000 databases that have tables which are full-text indexed. In particular I index an image column and specify a document type column. This type column often has a compound extension like '.doc.gz' and I've written and enabled an IFilter on the box to take fil...more >>

Hi I would like to know how to use Query Analyzer to get information from the Full Text Search Catalog: 1. Status 2. Item Count 3. Catalog Size 4. Unique Key Count 5. Last Population Date Also, I like to know how we can capture the data from the Table -> Properties -> General Tab, in pa...more >>

I'm having a problem when "&" is in the search term. For example, I have an article in my database that has "flat monitors & Toshiba magic". When a user does a FTS using that search term (or, here's some SQL: SELECT * FROM FREETEXTTABLE(forum_pacs,*,'"Flat Monitors & Toshiba magic"') ORDER...more >>

I have a FT index which idexes a image column (files). The table does not have a timestamp column, has about 80k rows. I have created the index and populated it successfully, took 3 hours and the 4 cpu's were at 95% the whole time. I would like to keep this FT Index updated. I can not use in...more >>

I am new-hand for sql server 2000 . I want to catalog of sql server 2000....more >>

Hello, All, I am migrating an SQL database from an SQL 7 server to an SQL 2000 server. All of the usernames, tables and stored procedures migrated fine. When I point my asp code from the old database server (which works as expected) to the new database server I get the following error... ...more >>

I've tried to rebuild catalog and start a full population but am gettting the error message 800700e9 The crawl seed cannot be accessed in the event viewer. I've followed what it says in the other articles that Builtin admins has sysadmin rights and the SQL Service account was changed in EM ra...more >>

My company has a client using SQLServer 2000 SP3a. Every so often (approx. once a week), the full-text indexing will fail on one of our database tables. We are unsure why, but have noticed some rather bizarre behavior associated with this failure. (Normally, we restart the MSSearch service ...more >>

Hi GURU, I wonder if the code inside the .mdb or .adp file can be indexed? if yes, what iFilter can do that? Thanks....more >>

Got a strange problem. Had a SQL 7.0 Box with FTS on a database. Worked fine except for one quirk we never tracked down. Starting up the MSSearch Service would fail 1/2 the time due to timeout. Other 1/2 would take a long time (like sometimes an hour) to start. Upgraded to SQL 2000, n...more >>