I want to do a CONTAINS search on several columns combined. This example searches each column separately, so that a record is not included that has one of the search terms in the Desired Position and the other two search terms in a section body. SET @SearchPhrase = 'Engineer AND SQL AND VB'...more >>

I've started to use the code within searchpage and am having trouble with Noisewords at the beginning and end of the search phrase. For example: When I specify "Bill and any Manager" the result is "Bill Manager". When I specify "any Manager and Bill" the result is "any Manager Bill". I ...more >>

Hi FTS will not populate the catalogs. 0 Items I have a new installation W2003 with SQL2K Sp3 The SQL Server is running with a high security configuration All the SQL services are running under an account Domain\SQLService which is a plain old user in the domain and on the SQL Server box Th...more >>

hi, i cant seen to change my color settings or the size of my desktop. i dont know what my driver is and i have tried installing others out of the list given on the win98 disk and it isnt working, can somebody please help me out because i cant view anyting in a higher resolution and i cant...more >>

My SQL is instaled with CAse-Insensitive and Accent-Insensitive, but when I search some thing with Full Text Search the result is diferent using accent or not. My server is a Windows 2000 server and MS SQL Server 2000. Tia Marcos Stabel ...more >>

sql2000 build 818 i have 3 tables that have change tracking on and update index in background on. i created a text filegroup and assigned those 3 tables to that text filegroup. after that was done, the change tracking is now off and so i had to go back and re-enable change tracking. shouldn't...more >>

Microsoft Search service does not appear in my list of Services, and full-text menu items are grayed out in Enterprise Manager. Is FTS not available on Windows XP Professional computers? I have the developer edition of SQL Server from a Microsoft Universal subscription. Generally I develop o...more >>

Notice that I said with not within. On a Win 2K machine this query works, on a 2003 same sql build the query returns way too many rows. My guess is that I'm getting every row where HEADLINE_EXROUTING contains the letter 'V' somwhere in the entire text, instead of where it contains the text "...more >>

Hi Can someone tell me why I can search multiple columns in 1 table using a single CONTAINS with 'OR' operator but it dosn't work for 'AND' queries? I want to be able to do 'AND' searches accross 50 odd columns in a table. Here's an example to show you what I mean (A Full-Text index is working...more >>

When creating a new Table Schedule, there is an option for a Job Type of "Update Index". I though this was Change Tracking, but it doesn't seem to be. I still had to manually select Change Tracking from the full text menu. What is Update Index? Thanks...more >>

hello, i have been executing the following statement SELECT title FROM searchtable1 WHERE CONTAINS (filecontent, '"adelaide"') (which works ok on the development box) and receiving the following error (on the live site) Microsoft OLE DB Provider for SQL Server error '80040e14' Exec...more >>

I have just begun to experiment with the full text searching capabilities in SQL2000. Very happy so far! Nice work. I like the INFLECTIONAL results. When the user makes a change or addition to a row's full-text-indexed column (e.g. adds the phrase "now available in brushed aluminum" to the Desc...more >>

sql2000 sp3a. i was using enterprise manager to create a full text index on a table. i would pick the image column, the language, and then the document type column. when i hit the finish button, i'd get the following error "column names in each table must be unique. column name 'doc_type' in...more >>

Hi ! I have some office documents which I am storing as image type (as blobs) in a table. I have some additional header data in the blob other than the content of the office documents. Is there a way to integrate just the content of teh office document with the SQL server search? I know th...more >>

Is there a way to set up a value to teach the query to set up how much 'near' a word is respect another? Is there any other way to do it besides NEAR? Tnanks...more >>

Hi, We can successfully create catalogs on a database on our server. However, we can never get any data from any of the searches. We have since discovered a few errors in the Application log. Version of SQL running is: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2...more >>

Event ID 17055 3041 BACKUP failed to complete the command BACKUP DATABASE [master] TO DISK = N'\\ibm345\h$\program files\microsoft sql server\mssql\backup\master_db_200405180602.' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT What do I do to fix this ? ...more >>

Hi, i have problem with full-text search. I make full-text catalog and i run this query: SELECT * FROM tmp WHERE CONTAINS(Full_Text_Search, 'between') and i receive error Server: Msg 7619, Level 16, State 1, Line 1 Execution of a full-text operation failed. A clause of the query contained ...more >>

I have indexed 1 million rows of data in Yukon, and created a full text index that includes multiple columns. There is a column called "JobTitle" and a column called "Major", and a "Resume" column, as well as some others. To search this I can write. select top 50 firstname,lastname where con...more >>

I read many good postings here about the weird logic of full-text ranking, and I hope I finally got it (if it is possible at all ;). Yet... We biult an application to search in our database in varoius ways, incl. full-text search. I want to show users only "relevant" matches, i.e. matches that ...more >>

My problem is simple: i want to dynamic specified the columns in the ContainsTable, this is possible? Please see the example. <Code> Declare @Test1 int Declare @Test2 int Declare @Query varchar(50) Declare @Temp varcahr(50) --Test Set @Test1=1 Set @Test1=0 Set @Query='something' --A...more >>

hello, I have the following problem. Everything was working fine with the full text search. I created a catalog etc... now in EM, database->tools->"Full Text Indexing" is grayed out. I cannot use the full text indexing with tables (grayed out) and the full text search is marked as stopped...more >>

Are there any options available in queries that are searching textual = dates that have been indexed? Perhaps the ability to specify a range = and all matching records would be returned? Am I just dreaming? :-)...more >>

Hi, I'm running win 2003 and sql 2000 sp3a in spanish. When I search in a full text query for a verb (using contains and not an inflectional search) the result include the correct verb form but also the various forms of that verb . For example if I search "comprar" the results include "com...more >>

Hello, I'm relatively new to using full-text search. I'm working on a = document management program. Basically my data it stored in two tables, [Documents], and = [DocDetails], with a one-to-many relationship. [Documents] contains a = record for each document stored, and [DocDetails] has man...more >>

Hi I get this error on my Full-Text population job Full-text auto propagation is currently enabled for table '[dbo].[tablename]'. [SQLSTATE 42000] (Error 15633 Does anyone have any idea on this ? There is not information on Net on this, so your input will be highly appreciated. T...more >>

I'm having a problem with the full text index rebuild process. Previously when I did a full rebuild the process stopped, then the server rebooted and the rebuild started over and completed. I had hoped this was just a fluke but this last time I set up an indexing job to run at 2 am and the same...more >>

What are the main differences between SQL FTS and Index Server FTS? Thank you. Best regards, Emil Mustea ...more >>

Hi, We have SQL Server private installation on which we are developing an application and public installation on whict we will be deploying the application. All instances have run Windows 2003 Enterprise Edition with SQL 2000 SP3. However, the public installation MS Search is not functioning ...more >>

Hi, I am running a loop through a cursor, and then passing the search string to a full-text search. This started out working beautifully, but now I keep running into the following error: 'Server: Msg 7607 Search on full-text catalog 'FTCNationalCIBR' for database ID 6, table ID 2260...more >>

Consider the following: Table setup: ID Message-ID References 1 IDA 2 IDB IDA 3 IDC IDA IDB 4 IDD Given the above table I am trying to select the ID, Message-ID along with t...more >>

Since I don't have access to the Beta newsgroup, I'll post here. We are looking at evaluating the Full-Text capabilities for Yukon vs some of the other third party vendors such as Verity, Autonomy, etc. We have a large document base, over 20 million which are naturally partitioned into 10 Ve...more >>

was that MSDE is a free distribute software and have not access limitation for the number of the user??? where i can find the more license infor for MSDE thanks in advance ...more >>

Hi I'm trying to figure out exactly how the CONTAINSTABLE ranking algorithm works in SQL Server 2000. Can anyone point me to some technical documentation describing what the algorithm is? From the descriptions I've been able to find it sounds rather like TF/IDF but I'd be grateful if someone could...more >>

I found 2 locations for noise files on my server C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\Confi & c:\program files\Common Files\system\mssearch\data\confi Does one preceed the other when using a SQL query. I am guessing the SQLServer one does ...more >>

When I try to execute the following stored procedure: exec sp_fulltext_database 'enable' I get the following error: Server: Msg 7619, Level 16, State 1, Procedure sp_fulltext_database, Line 46 [Microsoft][ODBC SQL Server Driver][SQL Server]Execution of a full-text operation failed. The pa...more >>

Help. Have the following: -------------------------------------------------------------------------------- SELECT (ISNULL(CAST(RANKTBL1.RANK AS decimal),0)) + (ISNULL(CAST(RANKTBL2.RANK AS decimal),0)/10) AS RANK, RANKTBL1.RANK AS RANK1, RANKTBL2.RANK AS RANK2, items.itempkid, ...more >>

We are running Fulltext on SQL2K sp3a with hotfix 031 cluster server running in WIN2K. Fulltext was working fine on the primary side. When we failover test to the secondary node, we are getting the following error in the gather logs when we run incremental job to populate fulltext 5/4...more >>

I am running SQL 2000 SP3a on Windows 2000. Is it possible to obtain accent insensitive results from full-text searches so that a search for café will return all records for café and cafe as if these were the same? In the four queries below queries 2a and 2b return the same results as each ...more >>

(SQL Server 2000, SP3a) Hello all! I'm trying to cobble together something that will let me reference the "noise.eng" (the English list of the Full Text Search service ignored words) through Transact-SQL. I'm trying to reference the "noise.eng" file that's located in: C:\Program Files\C...more >>

Hi, We're using the SQL Server Full Text Engine to implement a search engine. Users can enter queries which are then executed using the CONTAINS statement. I can't find any documentation that indicates the maximum allowable size of the contains_search_condition clause. Our users' search terms can...more >>

Is is possible to search across multiple tables (Parent-Child)? contact(contact_id, name) role(role_id, description) contact_role (contact_id, role_id) How can I find all contact where the search string is in the contact name and or roles description? I tried to search on contact the...more >>

select @@versio Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporatio Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4 How you tell the indexer (SQL 2K with WIN2K) to include () , /, - and all other special charac...more >>

Hi all, I'm doing some experiments with Indexing Service and MS-SQLServer 2000. With the help of the documentation, I easily managed to configure the local Indexing Service as a linkedserver and now I can run full text query from SQL accessing both the SQL tables and the Indexing Service cat...more >>