Full Index Searching Question
I have enabled Full Index Searching on my SQL Server 2005 database and it is working correctly.
The problem I am having is this. When I search for the word "Spider-Man" I get results containing "Spiderman, Spider-Man and Spider Man" which is what I want.
However, when I search on "Spiderman" I do NOT get results containing "Spider-Man or Spider Man"
Also when I search on "Spider Man", I only get "Spider-Man" and not "Spiderman"
Is there an EASY way to get results on any form of SpiderMan on my search?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Full-index Does Not Fully Populate When Doing Start Full Population
I have sql server 2000. I copied a database from one server to another. I have one table that has a full-text index. When I transferred over the database, the index still existed, but was not populated. I made sure the path for the file is pointing to a new correct location. I did "start full population". It only populated one entry @ 1MB. On the old server the index is 100MB with more than 3 million records. I tried rebuilding, re-creating, and it all works, but when I run "start full population", it only populates 1 record. I double checked the table in question and it has over 3 million records and proper primary key. How do I resolve this.
View Replies !
View Related
Full Text Searching
I am trying to run a full text serach on one field, a Varchar 2000. say the field contains: (before you break the seal of your new product box, please be careful to read all the instructions) ...for example I search for keywords that may be in this field Like: product box seal instructions and this row is included in the result set but I would like to leave out words like all pronouns and 'a' and 'I' ...words that aren't going to matter to the search. Does someone know where I can stgart in doing this full text searching? Thanks, Eric
View Replies !
View Related
Full Text Searching
I've assumed responsibilty for a sqlserver 2000 that has many databases and has only 1 database that uses full text searching. That 1 application now wishes for me to update the noise words file to remove the single characters. As far as I can tell, no other application is using the full text searching since I don't see any catalogs created for any of them. So, if no other databases and applications in this sqlserver have catalogs created for them, can I safely assume that changing the noise words file will not impact any of them even if the other databases do have text fields in some tables?
View Replies !
View Related
Full Text Searching
I have defined a full text index on the firstname column for the employee table. I am using SQL Server 2000 on Windows 2000. I enter a query using SQL Analyzer such as select * from employee where contains (*, 'Brian') I receive the error message : Server meg 7619.level 16, state 1 , line 2 Language/Database cache file could not be found. Does anyone have any ideas Dave
View Replies !
View Related
Full-Text Searching
I`ve just starting playing around with version 7.0 and was wondering if anyone knows how to implement the Full-text Searching feature. Its sound like a neat feature if I could just get it to work. Thanks in advance Joe
View Replies !
View Related
Full Text Searching
Hi i am really new to full text searching, I have created a catalog using: sp_fulltext_catalog 'textcatalog','create' and now i want to add a table with: sp_fulltext_table 'Product', 'create','textcatalog', 'ProductID' where product is a table in my database and productID is the primary key to that table. The primary key cannot be null, But i get an error: 'ProductID' is not a valid index to enforce a full-text search key. You must specify a unique, non-nullable, single-column index. Can any one point me in the right direction? Thanks in advance Tuppers!
View Replies !
View Related
Full-text Searching
Are there any plans to add full-text searching capability to SQLCE? I know it's available in SQL Server Express but it would still be useful for an embedded/desktop application -- SQLite recently added this.
View Replies !
View Related
CONTAINS In Full Text Searching
Hi I've used CONTAINS on a varchar field. in SQL SERVER 2000 the query was "Select name from description where CONTAINS(name,' "donot*" ') say if I search for "Select name from description where CONTAINS(name,' "donot a*" ') ---it doesn't return rows. as might be it is seeing that 'a' as the starting letter of AND key word which is used in CONTAINS but how to tell that it is my next letter in the search Really I need more clarity on this... Thanxs in advance
View Replies !
View Related
Full Text Searching With Paramters
i have a query in SQL Server 2005 that uses a parameter like so:ALTER Procedure [dbo].[p_FullTextEquipmentSearch] @search as nvarchar(50), as SELECT * FROM EquipmentView where contains(*, @search); what i want to so is add more parameters to the query so that the user can choose either 1 or many for the search can anyone help me on this
View Replies !
View Related
Full Text Not Searching All Fields
I have a major issue with an application that I wrote last year. The business I wrote it for changed from a Win2000 Server to Win2003 SBS. They installed SQL 2000, and we moved over the application. It was previously using SQL7 on the 2000 machine. Anyway, the application searches through the fields and finds data on their film projects. The idea being that they can lease some stock footage, or even reuse some they may have already. It used to work great. Now, however, when they do a search looking for "all of" in the fields, it returns 0 results. The "any of" works still. The query had to change based on the differences of the server, but it works just great. The query analyzer works, and returns 300-or-so results...which is the desired effect. However, in the application, it does not. I know it's right, because I can search on some items, and I can get some limited results, but they seem to only be finding words in the "description" field. It appears that it is only searching through the description of the footage shots, but not the medium (for example: film or video) or the actual show they were filming it for. All of those fields (columns) are in the FT catalog, and I've had another person watch to make sure I included them when I rebuilt it. Now, here's the thing. The EXACT same coding works on an EXACT version of SQL 2000, but it's on a Win2003 Standard Server (not SBS). The Standard server is not theirs, so it can't stay there. The same data is in that DB, and it works just great. So I know it's not my coding, I know it's not my Query, and I know it's not the data. Is there any reason that this SBS server might not search all the fields or all the fields may not populate properly in the Full Text Catalog? This has been going on for months, and I'm completely out of ideas. Can anyone suggest anything? Thanks for any and all thoughts. rob
View Replies !
View Related
Problem With Full Text Searching
I'm wrtiting a local site search egine but I need to make use of functions like FREETEXTABLE for instance. In order to use this I have to have the' Full Text Search table' enabled for a table. Now the Microsoft Search Service is running in MSDE; of that I'm sure. However when I try to enable the full text searching on a table or database the option that I'm supposed to choose is grayed out which means I can't select it. What's wrong? What do I have to do to be able to use that option? I' short of time and would appreciate n answer a.s.a.p. Thanks
View Replies !
View Related
Full Text Searching Problem
Kind of a no code question, Is it possible to add a word to the index catalog of MS SQL Server 2000 directly? The reason for this is that a web based search engine we are working on fails to return results when given a certain hyphenated acronyms such as "4-H" this string is broken as 4,h and resolved as a noise word and thus no indexed when there are numerous pages contained in the database which have this string. I was wondering if it's possible to just insert special cases of strings like that into the catalog? or do I have to create a custom wordbreaker?
View Replies !
View Related
Full-Text Searching Issue
The Microsoft SQL full-text indexing seems to be working fine, however why does it only work when I insert a value and it fails to work when I insert the @txt varaible like the original StoredProc below ? Replaced "name like '%' + @txt + '%'" with 1. FREETEXT(NAME, 'ginger') --> works 2. FREETEXT(NAME, 'txt') --> fails 3. FREETEXT(NAME, @txt) --> fails 4. FREETEXT(NAME, '@txt') --> fails ------------------------------------------ ** Originial ** CREATE PROCEDURE p_SEARCH_PRODUCTS @TXT VARCHAR(500) AS DECLARE @today DECIMAL set @today = DBO.DATETOMS(GETDATE()) SELECT 0 CATEGORY_ID, P.PRODUCT_ID, 0 CAT_COUNT, P.NAME, P.SHORT_DESC, P.THUMBNAIL, MIN(S.PRICE) PRICE, P.NAME_EXT, 0 PACKAGE_FLAG INTO #OUT FROM PRODUCT P, SKU S WHERE P.PRODUCT_ID IN ( select PRODUCT_ID from product where name like '%' + @txt + '%' ) AND P.PRODUCT_ID=S.PRODUCT_ID AND @today between P.DATE_ACTIVATE AND P.DATE_DEACTIVATE AND P.ACTIVE = 1 AND (P.DELETE_FLAG = 0 OR P.DELETE_FLAG IS NULL) GROUP BY P.PRODUCT_ID,P.NAME,P.SHORT_DESC,P.THUMBNAIL,P.NAM E_EXT UPDATE #OUT SET PACKAGE_FLAG = 1 WHERE PRODUCT_ID IN ( SELECT PRODUCT_GROUP_PRODUCT_ID FROM PRODUCT_GROUP G WHERE PRODUCT_GROUP_SUB_TYPE_ID IN ( SELECT PRODUCT_GROUP_SUB_TYPE_ID FROM PRODUCT_GROUP_SUB_TYPE WHERE PRODUCT_GROUP_TYPE_ID =1) ) -- 1 IS QUALITIES USED FOR PACKAGE OPTIONS OR PRODUCT_ID IN( SELECT PRODUCT_ID FROM PRODUCT_GROUP G WHERE PRODUCT_GROUP_SUB_TYPE_ID IN ( SELECT PRODUCT_GROUP_SUB_TYPE_ID FROM PRODUCT_GROUP_SUB_TYPE WHERE PRODUCT_GROUP_TYPE_ID =1) AND PRODUCT_ID <> PRODUCT_GROUP_PRODUCT_ID ) SELECT top 100 * FROM #OUT GO
View Replies !
View Related
Full-Text Searching Of Symbols
I have successfully set up a full-text catalog for a blob field in one of our tables. I am trying to search for words like 'C++' and 'A++' or 'C'. I know who to accomplish the single letter part, by removing it from the NOISE.ENU file, but how do I get it to recognize the ++ part? I need to be able to search on -, _, = and +. If anyone knows anything, it is much appreciated. Jake Massey
View Replies !
View Related
PROBLEMS WITH FULL TEXT SEARCHING
I am very new to SQL and Access projects. I have created the full text catalogs for my tables, so that I can search all the tables at the same time, from any of the fields in the catalogs. I have created the following procedure:- create procedure usp_full_text(@findtext varchar(255)) as select set_id as URN, input_date as date_of_record from set_records where freetext (*, @findtext) There are a few union selects under this, but If I search for perhapse 'SMITH' from within access, then this will bring back all the records which have smith in them somewhere, which is good, however if I repeat the search for 'smit' then I get no records returned. How can I change the code to find the parts of words, or string of charactors, and how can I set this to do a soundex search? Hopefully all this is possible, i just need pointers on how to achieve this, or I could be sat there for days. Many thanks for any help you can offer.
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
Is Column Weighting In Full Text Searching Possible?
Hello, I'm using containstable to do full text searching. I know that you can provide weights on the actual search term entered by the user. However, is it possible to add weights/priorities on certain columns that are being searched? My containstable statement is currently the following: ... containstable(Articles, (Title, Abstract, Keywords, Body), @SearchTerm) ...However, I want the rows that match on the "Title" column to be ranked higher than the other rows.
View Replies !
View Related
Full Text Searching....THOUSANDS Of Records!
Hope I am in the correct section. I am installing a FTS system on an existing system (that used LIKE % queries!! hahaha) Anyway, it is working pretty well (AND FAST!) but when I type in a common word like "damage" I get like 32,000 records. Now, the server handles those records in about one second but the ASP page that returns the results takes about one MINUTE to download. When I save the source, it is almost 12 MEGS!! So, basically, I am streaming 12 megs across the pipe and I want to reduce that. I would like the system to detect over maybe 500 records and cancel the search. I have put a "TOP 500" into the search and that actually works pretty well but is there a better/smarter method? Thanks! cbmeeks
View Replies !
View Related
Full-Text Searching In SQL Server 2000
I am trying to create a full-text searching in SQL Server 2000, after trying different ways still failed. I use a Windows login to start both MSSQLServer and SQLAgent services, created a full-text catalog in pubs database employee table in EM. Start full population but the status is always idle and never get populated. My Windows login is a member of sysadmin role. I extracted the gatherer log: - The gatherer has started - The initialization has completed - Started Full crawl - MSSAL75://SQLServer/75d7831f Add Error fetching URL, (800700e9 - No process is on the other end of the pipe) - Completed Full crawl As I have been struggling in doing this for several days, if anyone has successfully doing a full-text search, please give me your experience and steps on how you did it successfully. Thanks
View Replies !
View Related
Full Text Searching Eventually Utilizes 100% CPU
For one day, this SPROC executes very quickly to return results on a Full Text catalog. ALTER Procedure dbo.sp_RSSHarvestedHeadlines_FullTextSearch ( @ORKeywords varchar(4000) = 'xxxx', @ANDKeywords varchar(4000) = 'xxxx', @NOTKeywords varchar(4000) = 'xxxx', @SourceID int = -1, @IsHidden bit = null ) As set nocount on SELECT HHL.HeadlineID, HHL.Title, HHL.Link, HHL.[Description], HHL.PubDate, HHL.GMTDateAdded, RSSSources.SourceTitle, RSSSources.SourceLink FROM RSSHarvestedHeadlines HHL INNER JOIN RSSSources ON HHL.SourceID = RSSSources.SourceID WHERE HHL.PublishedFlag = 0 AND (@IsHidden is null OR HHL.HideFlag = @IsHidden) AND (@SourceID = -1 OR HHL.SourceID = @SourceID) AND (@ORKeywords = 'xxxx' OR (CONTAINS(HHL.Title, @ORKeywords) OR CONTAINS(HHL.Description, @ORKeywords))) AND (@ANDKeywords = 'xxxx' OR (CONTAINS(HHL.Title, @ANDKeywords) OR CONTAINS(HHL.Description, @ANDKeywords))) AND ( @NOTKeywords = 'xxxx' OR ( (NOT CONTAINS(HHL.Title, @NOTKeywords) AND NOT CONTAINS(HHL.Description, @NOTKeywords)) ) ) ORDER BY HHL.GMTDateAdded DESC, HHL.PubDate DESC But somethign happens overnight and in the morning the sproc times out. While running (even from a new query window on the SQL 2005 server itself) it utilizes 100% CPU until it times out. When I pass default parameters to the sproc (not using any part of the query that uses Full Text) the sproc returns every record in the database very quickly. No hang ups. But the moment I add any text in say the @ORKeywords parameter, for example, the sproc utilizes 100% CPU for maybe 15 seconds and then times out. By accident I discovered that I can fix this temporarily by copying the database. I don't use the new copy or anything. Just the act of copying the database fixes it. The sproc then executes normally, and quickly. But the next morning it's back to slow again. Note, over night I am adding about 1000 records to the table. Would automatic updates to the FT Catalog choke on 1000 records? Also note that one of the fields being cataloged is a "Text" field (blob). Would that cause this? Would what text is being added to the table matter? What if an invalid character was added (like some european character or a control character)? Would FT indexing hang up on that? I am at a loss. The following code will recreate the table: CREATE TABLE [dbo].[RSSHarvestedHeadlines]( [HeadlineID] [int] IDENTITY(1,1) NOT NULL, [SourceID] [int] NOT NULL, [Title] [varchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Link] [varchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Description] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PubDate] [datetime] NULL, [GMTDateAdded] [datetime] NOT NULL CONSTRAINT [DF_RSSHarvestedHeadlines_GMTDateAdded] DEFAULT (getutcdate()), [GMTLastHarvested] [datetime] NOT NULL CONSTRAINT [DF_RSSHarvestedHeadlines_GMTLastHarvested] DEFAULT (getutcdate()), [HideFlag] [bit] NOT NULL CONSTRAINT [DF_RSSHarvestedHeadlines_HideFlag] DEFAULT ((0)), [PublishedFlag] [bit] NOT NULL CONSTRAINT [DF_RSSHarvestedHeadlines_PublishedFlag] DEFAULT ((0)), [EditStamp] [timestamp] NOT NULL, CONSTRAINT [PK_RSSHarvestedHeadlines] PRIMARY KEY CLUSTERED ( [HeadlineID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO
View Replies !
View Related
Full Text Searching Eventually Utilizes 100% CPU
For one day, this SPROC executes very quickly to return results on a Full Text catalog. ALTER Procedure dbo.sp_RSSHarvestedHeadlines_FullTextSearch ( @ORKeywords varchar(4000) = 'xxxx', @ANDKeywords varchar(4000) = 'xxxx', @NOTKeywords varchar(4000) = 'xxxx', @SourceID int = -1, @IsHidden bit = null ) As set nocount on SELECT HHL.HeadlineID, HHL.Title, HHL.Link, HHL.[Description], HHL.PubDate, HHL.GMTDateAdded, RSSSources.SourceTitle, RSSSources.SourceLink FROM RSSHarvestedHeadlines HHL INNER JOIN RSSSources ON HHL.SourceID = RSSSources.SourceID WHERE HHL.PublishedFlag = 0 AND (@IsHidden is null OR HHL.HideFlag = @IsHidden) AND (@SourceID = -1 OR HHL.SourceID = @SourceID) AND (@ORKeywords = 'xxxx' OR (CONTAINS(HHL.Title, @ORKeywords) OR CONTAINS(HHL.Description, @ORKeywords))) AND (@ANDKeywords = 'xxxx' OR (CONTAINS(HHL.Title, @ANDKeywords) OR CONTAINS(HHL.Description, @ANDKeywords))) AND ( @NOTKeywords = 'xxxx' OR ( (NOT CONTAINS(HHL.Title, @NOTKeywords) AND NOT CONTAINS(HHL.Description, @NOTKeywords)) ) ) ORDER BY HHL.GMTDateAdded DESC, HHL.PubDate DESC But somethign happens overnight and in the morning the sproc times out. While running (even from a new query window on the SQL 2005 server itself) it utilizes 100% CPU until it times out. When I pass default parameters to the sproc (not using any part of the query that uses Full Text) the sproc returns every record in the database very quickly. No hang ups. But the moment I add any text in say the @ORKeywords parameter, for example, the sproc utilizes 100% CPU for maybe 15 seconds and then times out. By accident I discovered that I can fix this temporarily by copying the database. I don't use the new copy or anything. Just the act of copying the database fixes it. The sproc then executes normally, and quickly. But the next morning it's back to slow again. Note, over night I am adding about 1000 records to the table. Would automatic updates to the FT Catalog choke on 1000 records? Also note that one of the fields being cataloged is a "Text" field (blob). Would that cause this? Would what text is being added to the table matter? What if an invalid character was added (like some european character or a control character)? Would FT indexing hang up on that? I am at a loss. The following code will recreate the table: CREATE TABLE [dbo].[RSSHarvestedHeadlines]( [HeadlineID] [int] IDENTITY(1,1) NOT NULL, [SourceID] [int] NOT NULL, [Title] [varchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Link] [varchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Description] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PubDate] [datetime] NULL, [GMTDateAdded] [datetime] NOT NULL CONSTRAINT [DF_RSSHarvestedHeadlines_GMTDateAdded] DEFAULT (getutcdate()), [GMTLastHarvested] [datetime] NOT NULL CONSTRAINT [DF_RSSHarvestedHeadlines_GMTLastHarvested] DEFAULT (getutcdate()), [HideFlag] [bit] NOT NULL CONSTRAINT [DF_RSSHarvestedHeadlines_HideFlag] DEFAULT ((0)), [PublishedFlag] [bit] NOT NULL CONSTRAINT [DF_RSSHarvestedHeadlines_PublishedFlag] DEFAULT ((0)), [EditStamp] [timestamp] NOT NULL, CONSTRAINT [PK_RSSHarvestedHeadlines] PRIMARY KEY CLUSTERED ( [HeadlineID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO
View Replies !
View Related
Full Text Not Searching Properly Whe Using Multiple Columns
Hi everyone, I have full text enabled on one a products table with multiple columns set for full-text searching. I am having a problem with the results and it seems that there is bug with SQL. However, I read somewhere on Microsoft's site a while back that this bug was fixed in SQL Server 2000 (not in Sql Server 7). I am running SQL Server 2000 with all the latest service packs on a Windows 2003 Server. Here is the problem: When a search is performed, SQL is supposed to search all the columns enabled for the keywords specified. It does that to a certain extent. SQL is only searching on the first column that it finds a match for. For example: If my table has columns ProductName, PartNumber, and Keywords enabled for full text searching, and it has the following data: Row 1: ProductName = 'XYZ Cable for the Sony M9999 TV' PartNumber = 'xyz' Keywords = 'tv cable, something else' Row 2: ProductName = 'Sony 100" Color Television' PartNumber = 'M9999' Keywords = 'sony tv, m9999' Row 3: ProductName = 'White t-shirt with drawing' PartNumber = '1212' Keywords = 'tv cable, something else, m9999' Now, with the data above, SQL is suppose to find all 3 records when doing a search for the keyword 'm9999' because all rows contain the keyword - in different columns but since all columns are enabled for full text searching, they should all be searched on every record. Instead, what it does is once it finds a match on one column, it only searches that column on the rest of the records. So if I search for 'm9999', it will find a match in ProductName for the first row and it will only search the ProductName on the remainder of the records which will result in only 1 record being returned because they contain the keywords in other columns. Obviously, these are not the results that I want especially because it may leave out the most important rows - in this case the most important may be row 2. Does anyone know if there is a fix for this issue or has anyone experienced this before? If you need me to explain more, let me know. Please help! Thanks! - EM
View Replies !
View Related
Full Text Searching Using Values From Multiple Tables
Hi All- I have a bit of an issue and hope that someone can shed some insight into the matter. Basically, I had created a very simple search application that searched a database using full text. What I did originally with mySQL was to take the fields from the tables with which I wanted to search (had criteria that I wanted to search upon) and then join those fields, creating a new table called search_table. This table had a full text index on it and made searching very fast and accurate. It would allow me to search for a string and spit back the records related to that string whose accuracy was calculated via the joined table's full text index. Now, I need to search the same fields with a MS SQL database. Unfortunately, this time around I don't have the luxury of being able to create new table just for searching. From what I understand I can not create a full text index on a "view", but I was reading an article that indicated that it might be possible to create a full text index that encompasses different fields from different tables and calculates relevancy based upon that. Does anyone have any ideas as to how I might go about modifying this search to make it work? Thanks in advance. infinity003
View Replies !
View Related
Full Text Searching With SQL 2005 Express Advanced
I'm using the Full text functionality of SQL 2005 Express Advanced and it works well. However, the first time a query is run it take 20 seconds or so to actually return the search results. Thereafter, the search results are almost immediate. That would be fine, except that if no further search is performed for approx 15 minutes or so, then we are back to the first scenario where it takes 20 seconds to return the results. I assume this means that the full text catalog is not being held in cache at the server? Is there anyway to force it to do this? My first thoughts were that Full Text within 2005 was an excellent tool, but if the first search always takes a long time then I will have to re-think as I can be sure that customers will get extremely annoyed at the response. Do you know if there is any way around this or if there are any fixes imminent for this problem.....indeed, is it a problem or am I missing a fundamental setup issue? What would be the implications if I created a small console application to perform a full text search once every minute at the server to keep the index cached? many thanks
View Replies !
View Related
Full Text Index
Could Full Index option only be configured during installation? When Itry sp_fulltext_table on a table, I get the message that full text isnot enabled for the system.--sharif
View Replies !
View Related
Full Text Index
I am trying to enable full text index on all of my databases but notices that it is grayed out. Also the service Full Text Index service msftesql.exe is not installed. I have tried running the install again but it says nothing has changed on the machine so it just stops the install... Hope someone can help me.
View Replies !
View Related
Full-Text Index
I am having an issue creating full indexes on both instances of an ActiveActive SQL Server 2000 cluster. I get the following error when trying to create the catalog: Access is denied to $SQL PATH$, or path is invalid. Full-text search was not installed properly. Does anyone have any suggestions that I may use to create the indexes?
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
Full Text Index On A View
What is the procedure to create a full text index on a view? I createdfull text indexes on the underlying tables for a view, but when thequery is run against the view I am getting the errror message:Server: Msg 7601, Level 16, State 1, Line 1Cannot use a CONTAINS or FREETEXT predicate on table'dbo.apcgd_globaldir_master' because it is not full-text indexed.If there is a document which outlines steps to create a full text indexon a view that would be great.Thanks in advance.Raziq.*** Sent via Developersdex http://www.developersdex.com ***
View Replies !
View Related
Population Of Full-text Index
Hello , i need to work with a full-text index. Everything works fine. When i start EXEC sp_fulltext_catalog 'WGtestCatalog', 'start_full' nothing happens and the population is 0. Can anyone please give me a hint.. thanks Werner
View Replies !
View Related
Full Text Index Not Populating
I have a table with 13,000,000 records. I want to generate a full-text index on one column (a varchar 2000). I am able to define the full-text index, but when I click on "Start Full population", there is virtually no activity (no disk activity, no CPU activity, very little to indicate anything is happening. When I check the properties of the catalog, it shows 1 MB size and 0 records in the catalog. The status of the catalog is "idle" and the display in EM shows that the last full population occurred at (about) the time that I generated the population request. I have generated the request by using EM (right click on table) and through SQL Agent with the same result (no catalog generated). I am running SQL 2000 (SP4) on Windows 2000 (SP4) with 4 GB RAM and sufficient disk space available. I have enabled the full-text service and verified that it is running (I have stopped and restarted it as well). I have worked with Full Text indexes before and never had any kind of issue before. Any thoughts or suggestions would be welcome. Regards, hmscott CREATE TABLE [OMBRE_AUDIT_LOG] ( [LOG_SEQ_NBR] [numeric](18, 0) IDENTITY (1, 1) NOT NULL , [APP_NAME] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [USER_ID] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [USER_ORGANIZATION] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [ACTION_START_DATE] [datetime] NOT NULL , [ACTION_END_DATE] [datetime] NULL , [ACTION_CODE] [int] NOT NULL , [VIEW_NAME] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [USER_DEF_TRACKING_NBR] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [CMD_XML_STREAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [REC_CREATE] [datetime] NULL CONSTRAINT [DF_OMBRE_AUDIT_LOG_REC_CREATE] DEFAULT (getdate()), [REC_UPDATE] [datetime] NULL , [ATTENTION] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [REASON] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , CONSTRAINT [PK_OMBRE_AUDIT_LOG] PRIMARY KEY CLUSTERED ( [LOG_SEQ_NBR] ) ) GO
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
Full Text Index Wizard
Can any one tell me how to enable a database or table to create a full text index on a particular table. Iam selecting the database and just clicking the tools, Iam unable to see the full text wizard in the drop down menu as suggested in BOL. Help in this regard is highly appreciated. Thanks. sv
View Replies !
View Related
Full Text Index Scheduling
Dumb question: What vb/asp/dts method would display the last time a full text schedule had been performed by the SQL-7 server? I'm getting request to be able to view this type of stuff and I was thinking a good report would satisfy this situation. Sorry for the dumb question.
View Replies !
View Related
Full Text Index Migration
How to migrate FULL TEXT indexes from SQL SERVER 2000 to 2005? Is it okay if I migrate the MSDB DB? Do i need to create the physical folders manually? ------------------------ I think, therefore I am - Rene Descartes
View Replies !
View Related
Full Text Index Return All
I've got a full text index working with a "CONTAINS" clause in the SQL. I'm looking for the character that I can place in CONTAINS(*,'WHATHERE') that will return everything. I've tried "*" and "%" but none of them will do it. Does anybody know? Thanks
View Replies !
View Related
|
TRACKER
