Looks like I made a mistake I hope someone can help me with. I backed up a SQL database that implements fulltext catalogs. I thought these would be included in the backup...I was wrong. Not a problem to recreate the catalogs except that the database still shows the references to the old ones. It...more >>

I made an ameteur mistake moving my sql database. I have 5 full-text catalogs and I thought they would come with the backup...well, they didn't. Now, in Enterprise Manager, under full-text catalogs, I can still see them. I cannot delete, rebuild, or do anything with them though because I get a...more >>

Howdy I've got 2 databases on the same SQL server with full text indexes on the columns of tables, and one when I do a full text search on with a noise word eg 'a' it returns results with a in it, and the other one gives the 'ignored words' error. When I do sp_help_fulltext_columns on th...more >>

Hi, I need to do a sum this way : Select Field1, Sum(Field2) as sumField2 From Table1 Group By Field1. I think the syntax is correct, but the problem is that Field1 is of type Text (and not varchar). So I receive an error telling me I can't "group by" with a field of type "Text". Is there a w...more >>

I would welcome opinions on whether FTS would help in our scenario. The table has about 28 million rows and has about 10,000 rows added every morning in an intensive batch process. Then another batch query process is run that looks for partial name matches. Eight of the fields we query ag...more >>

My OS is Windows XP Professional 2002, when i'm trying to install the Server Components for the FULL TEXT INDEXING using the SQL Server Standard Edition CD, prior to the installation it is giving a message saying "Microsoft SQL Server 2000 Standard Edition server component is not supported on th...more >>

Hi, Does anyone know a simple way to highlight matches using full text indexes in SQL Server 2005? []´s José ...more >>

Getting the following error in SQL 2005 : Msg 7696, Level 16, State 10, Line 1 Invalid locale ID was specified. Please verify that the locale ID is correct and corresponding language resource has been installed. Well my question is : Is it possible to install a language or do I have to ac...more >>

I perform a query against a database and it returns one set of results. I perform this query on an "identical" database and it returns a subtly different set of results. In detail. SERVER A I have a table that has a field 'myField' that is of datatype TEXT. This table has a full-tex...more >>

Hi, group, Made these days some tests and not understand very clear how contains or containstable perform the search. The catalog was built on 2...5 columns, various scenarios. I tried with 2 words I am sure they exists in 2 different fields, but contains nor containstable does not return ...more >>

Running on Sql Server 2000, I have a catalog set to do an incremental populate every 5 minutes each day. But when I make a change to a record and do a search on it, it doesn't find it, even after about 20 minutes. But if I manually do the incremental population, it then works. Why wouldn'...more >>

Can u install FTS later on? I have a clustered env. and due to failure in registering FTS the entire install is rolling back? so perhaps I can delete the FTS Resource and install it later... TIA ...more >>

I have a full-text index on a Title column in a Books table and I have a CONTAINSTABLE query that seems to work well in most cases. Recently I discovered that the query was failing to return an expected result. When I search for titles containing the word "shining," I expect the following ti...more >>

Hi Gyus, I have a quick question. Can you run full text search on a column tha contains ntext data? Thanx.. ...more >>

I am attempting to create a query with a "dynamic" CONTAINS query, e.g. DECLARE @Keywords VARCHAR(128) SET @Keywords = NULL SELECT * FROM Jobs WHERE (@Keywords IS NULL OR CONTAINS(JobTitle, @Keywords)) However, the CONTAINS function seems to behave very weirdly when OR is involved. Eve...more >>

Hello, I use sqlserver 2005 with fulltext. I want to search for multiple words in a single word field. How can I do this. For example : Field to search = "Iwanttogohome" "homewant" "togohome" Searchquery words = want home My example should find all 3 of the results. It should find a w...more >>

When submitting this Querey in SQL Server 2005 SELECT FT_TBL.Firstname, FT_TBL.LastName, Key_TBL.Rank FROM [user] AS FT_TBL INNER JOIN CONTAINSTABLE([user], Firstname, 'ISABOUT (Christian weight (.1), Ian weight (.2))') AS KEY_TBL ON FT_TBL.userid = KEY_TBL.[KEY] I get this message: ...more >>

Hi, How to find full text index is exist in the table or not ? like that how to find normal index is exist in the table or not ? Thanks in adv. ---> Murali <---- ...more >>

Hi - I've looked on Microsoft's web site: http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q240867 and not yet been able to find a full answer to my question. I'd appreciate any insight from others: I have a database that has full text indexes on it, that I need to log ship to mu...more >>

I'm currently building a product that will need to index and search roughly 500 million documents (perhaps more). Currently I have about 60 million documents in the index (table size about 100GB and index size about 35GB) Performance is (obviously) getting worse and I doubt my current archite...more >>

i have a C# program which connect to sql 2k each time i use any arabic word in search i got the following error Msg 7619, Level 16, State 1, Line 1 *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hello, We are developing an application against an MS SQL Server 2000 database which requires that we implement full-text searching across columns in multiple tables. The research that we have conducted seems to indicate that this is not directly possible within SQL Server 2000. And we can ...more >>

I've got a full-text index on a table in which I've got word docs and pdfs. I want to parse out certain types of content from these documents, and include the parsed content in the info I give back to the client. In this case, I want to collect the e-mail address(es) from each document yielde...more >>

Is it possible to do full text search on multiple tables and having one rank for all searches? Ive read a lot of articles that gives me code samples on doing FTS on multi tables but they gave me multiple ranks for each search....more >>

I've got a full-text index on a table 'items' with an image field 'item' into which I've imported word and pdf documents. I've only got ~10 docs imported currently, for testing. I know that each of these documents, except for one, includes the term 'ontology' or 'ontologies'. I've got the fol...more >>

Active-active cluster. The second node was reinstalled after a hardware failure. The MS Search service is started. But when I try to query full-text the error message shows up: Server: Msg 7609, Level 17, State 1, Line 1 Full-Text Search is not installed, or a full-text component cannot be lo...more >>

Hi! I have a requirement where I need to pass in the list of words (could be separated by space) and then I need to find all the rows in SQL which have each of these words in any of the 4 columns. Table ContactDetail columns addressLine1, addressLine2, Town, Country It can have data like...more >>

Hi, When I run the exemple from the BOL: USE AdventureWorks; GO SELECT Description FROM Production.ProductDescription WHERE CONTAINS(Description, 'ISABOUT (performance weight (.8),=20 comfortable weight (.4), smooth weight (.2) )' ); GO I receive the error message=20 Msg ...more >>

Hello: I know that this question is very ask it, but please tell where I found a god doc about all step that I can set to my sql server to optimizing the fts service, about hardware and software. I using ms sql server 2000 (8.0). Best regards and Happy New Year to every one. Owen. ...more >>

Hi, I've posted this message previously on sqlserver.server but somebody mentioned that it might be related to fulltext (though I don't think so) so I'm posting it here now. I recently migrated my DB to SQL 2005 from SQL 2000, the migration was mostly painless except for the following problem ...more >>

Hi, after installing SP4 I am having trouble with mssearch.exe using excess CPU. Typically all is fine for some hours, then the utilization jumps up to 60% and more. mssearch.exe can then only be stopped via killing the process. After a restart all is fine again. Any known problems with SP4...more >>