I need to parse the user's queries to but them in the format required by SQL, and in order to get correct results, I need to know what characters SQL considers to be word breakers. I am using US English...more >>

Is there a way to avoid wordbreaking functionality when performing a fulltext query in a german SQL Server 2000 on a Win Server 2003? Example: when using ... CONTAINSTABLE([column], "'posthorn'") ..., my resultset contains records containing "postfrisch" and "posthorn" because (I think) of the...more >>

Server: Msg 7635, Level 16, State 1, Procedure sp_fulltext_database, Line 46 The Microsoft Search service cannot be administered under the present user account Does anyone know how to fix this problem? The services are started under localsystem How to enable administration of ms search?...more >>

If I use the Indexing Services built into the OS, I can query the office doc properties (title, author etc). Is it possible to do this if I have an office doc stored in an Image field that is full-text indexed ? Steve ...more >>

Hi, I am using SQL Server 2000 to store a number of small Word documents in an image field that is being FT indexed (table name 'docs', image field name 'document', also have a column 'title' containing the name of the document). The docs look like this : Doc1 : The red apple is juicy ...more >>

Hi All, I have a table and a full-text catalog. The table is assigned to the catalog and index on description. Now I have to add one more column to this existing table called 'tilldescription'. The table will have 6-7 lakhs of data and I have to search using this tilldescription. I thought ...more >>

I have data in my full text column such as "men's shoes". When a user does a search such as "mens shoes" it does not return a match, because the user data does not contain the quote. If they search on "men's shoes" then it works properly. Anybody run into this and have ideas about how to ...more >>

I'm trying to do some local development so I installed Full-Text Indexing as part of the SQL 2000 Developer Edition on my Windows XP machine. The MS Search Service is running but the option is still disabled in EM when I right-click on a table. Thanks, Dave....more >>

Can anyone confirm whether Full-Text Indexing can be setup on a Sql Server 2000 compatible database running under Sql Server 2005? Thanks Ben ...more >>

I am getting this error message from SQL Server when attempting any full-text catalog operation: Error 7619: Execution of a full-text operation failed. The parameter is incorrect. The service appears to be installed and running on Windows 2003 Server and the error appears to be coming fr...more >>

Hi, I'm putting together a system and one of the requirements is to have a searchable CV function. I've got all the code to load the files on to the image fields, I've indexed and got it kinda working. Before I go to far down the road what is your opinion on having txt files instead of d...more >>

Platform = Intel 3.0G 4-way duel core (+ hyper-threading makes 16 CPU) running Win2003 AS - SP1 SQL Server 2000 (can't go to 2005 yet). 135G DB without catalogs - which are on a Raid 1+0 external drive via fiber (12 spindles). 1) I need to improve performance of full-text catalogs of a ...more >>

I looked all over the internet and can't find a straight answer, so hopefully someone here will know the answer for a fact. Question... Can the rank values of multiple containstable queries in different columns be compared to each other in order to achive a cross column ranking? If not, how...more >>

Hi, I'm using SQL Server Express for a project that I'm working on which would really benefit from having full text search abilities. As I understand it this isn't possible with the current release of SQL Server Express. I read on this page from msdn (http://msdn.microsoft.com/library/defau...more >>

Hello all, i have a freetext on a client's product catalog which allows customers to search all through the product names/descriptions/marketing text/info points etc. One problem creeps up though, which when googled is shown to be a common thing. Some products have hyphens in their names, e...more >>

I have a database table 'epda' that has a full text catalogue on it. The field of interest 'epd' contains two rows of interest. The first row has the following example text: 'This is some text and x73 is the value' The second row of interest has the following example text: 'This i...more >>

I am running the following select statement: select * from client inner join freetexttable (client,clname,'"General Mills"',2) as key_tbl on client.clnum = key_tbl.[key] data: General Investment & Securities Co. General Mills Inc. Smith Mills, Inc. It returns: General Investment with ...more >>

When I try to search a word by an ASP web page, it returns error '80040e14 , The query contained only ignored words'. I know the question maybe asked for many many times and I do search the Internet but cannot find the answer right for me. I use Windows 2003 SP1 and SQL server 2000, all are...more >>

hi, We have upgraded our sql server 2000 to sql server 2005. we have some serious problems about full-text search performance. What can we do about fulltext-search to speed it up ? what have been chanced from sql server 2000 in full text search. Thanks in advance Erdem KEMER ...more >>

I am having a problem getting SharePoint Service to acknowlwdge that Full Text Search is enabled. I upgraded the SharePoint MSDE database as documented without any problems, but when I go into SharePoint Admin section is says "The database this server is using does not support search." Accordi...more >>

Hello- Normally our mssearch.exe CPU is less than 5% even at peak times, and falls to 0 at night. But for the last few days mssearch.exe CPU usage remains close to 25% even when all the catalogs are idle and search queries are very infrequent. This happened a few months ago, and was fixed onl...more >>

We can't use the term "=" to compare the data directly ,of which type is text or ntext. Are there other good ideas to get the exact matchs? ...more >>

Hi all. I'm using MS SQL Server 2K SP3. I need to implement full text search in Russian. Now if I execute smth like: Select id_article From Articles Where FreeText (*, N' some words in russian ') I get an error: Server: Msg 7619, Level 16, State 1, Line 1 Execution of a f...more >>