.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

full-text search in SQl 2005 and 2008

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :Sql Server

Considering that full text search engine is now integrated into SQL in 2008 version comparing to 2005, has anybody notice any difference in full text search speed after migrating from 2005 to 2008 using the same type of hardware?



View Complete Post

More Related Resource Links

Full text search missing from one instance on one node of 3 node MSSQL 2008 cluster


Hello to all, 

I just started at a new client and on becoming familiar with the environment, I noticed that one of our instances on one node is missing the full text search option. The instance is not active on this node but I fear that if we ever need to failover it wont work.

The full text option is installed on the active node instance and the other passive node.

How do I add the full text search option to the instance on the node thats missing it ?

thank you.


How do I view Full-text search catalogs in SQL Server 2008 Express?


I've installed SQL Server 2008 express with advanced services on my Vista Home Premium, and have enabled Full-text search. 

"SELECT fulltextserviceproperty('IsFulltextInstalled');" returns 1, and using CREATE FULLTEXT CATALOG mycatalog I was able to create my Full-text search catalog. I was then able to create full-text indexes on my DB columns, and even search through them.

However, there is no &

Point In Time Recovery of Database with Full-Text Search enabled SQL 2005


Is this possible? 



Backup made at 10:30

changes made in system

Tail of the log backup taken at 10:35

Restore to point in tim 10:33 

At this point I get the error System.data.sqlclient.sqlerror: The File "sysft_yadayada_1" was not fully restored by a database or file restore.  The entire file must be successfully restored before applying this backup set.

BUT when I restore the database to most recent possible I have no issues..

when I do a select * from sys.master_files    sysft_yadayada_1 does not exist in that list, but  sysft_yadayada_5 does... When we were initially configuring fulltext search for this application we had a couple hiccups first till we got it working and thats the filename that ended up sticking.


Full text search in a Word document



  I´m currently programming a web search application in ASP.Net and having problem with full text searching. My requirements are:

1. Save a byte array from SQL server to word document as a temp file in a server side?

2. How to highlight the string I am currently searching in the Word document and return to the user the sentence with the highlighted string (like on Bing or any other search engines)? Is it possible to fullfill this requirement with full-text search integrated in SQL Server 2008?

Thanks in advance,




full-text search error


I have created procedure for full-text search and it works in SQL Management Studio 2008 (SQL Server 2008 Express) but in Visual Studio 2010 not - I have error:

Full-Text Search is not installed, or a full-text component cannot be loaded.

I have read somewhere that only admin can use full-text indexes - so how I can use full-text search in VS2010 ?

Maintenance plan to rebuild Full-text index ? (SQL 2005)

Is it possible, through the GUI Wizard, to create a Maintenance plan that rebuilds (rather than reorganise/optimise) a Full text index in 2005 ? The full text index is based on one table only - so would using the "Rebuild index task" in the Wizard do the trick ? I wouldn't mind if the other indexes on the table were rebuilt too, but main concern in the Full text Index. If not - then I guess it would be a scheduled job which does a ALTER FULLTEXT CATALOG catalog_name REBUILD, but I thought it would be nice to keep it within the - Management - Maintenance plans - section of SQL Management Studio. Also - should this be preceeded with a transaction log backup ? Had some issues rebuilding them last night - seemed a Log backup was needed.

Full Text Search Return no Result while "Like" does

Someone pls look at the picture and help me I tried Restart the serviceI tried restart the server But the number of row affected is still zero :(

Full Text Search architecture needs to be enhanced for true multilingual web applications

This is for the MS SQL Server development team that handles the code for Full Text Search. Hopefully you will read this. I developed a web application that supports multilingual content. As is typical in the real world, many people often need to create their content in multiple languages or even have multiple languages present within the same content. In my SQL Server database I have a single table that is used to store all the text from all languages. A single column is used to store this text. A separate column is used to identify the language of the content and uses Culture Codes like en-us, de-de, etc.. Furthermore, the format of the content could be plain text, html or whatever. Business logic at a higher level in my application code knows what the format is for each record because data is retrieved within the context of whatever a web page uses. For example, a user sending an e-mail would use plain text for the subject. For the body, html would be used. When these two pieces of information are stored in the same table, my code knows upon retrieving it what is text and what is html. It makes no sense storing a subject and body of an email in two separate tables. This is just a simple example but hopefully you get the point. After going through the documentation on FTS, it became clear to me that my table design is completely incompatible with the FTS paradigm. FTS requ

switch off full text search in sharepoint 2010

Hi I need to switch off full text search in sharepoint 2010 so that the search only searches on title filename and metadata. How can I do this? Juran

SQL 2005 Full Text Indexing


I am trying to create a full-text index on a table in my SQL 2005 Standard database. I ran into 2 issues:

  1. I had to execute the sp_fulltext_database procedure to enable Full-Text Indexing. According to the docs I should not have had to do this as "all SQL 2005 databases are enabled for full-text indexing". No biggie (one would think)...
  2. After I create the table, a PK index and a unique index over the INTEGER ID column, I create the Full-Text catalog. So far so good. However, when I try to create the Full-Text index, I get the following error message: "Msg 7653, Level 16, State 1, Line 1 'IAK1_TR_TextFullText_1' is not a valid index to enforce a full-text search key. A full-text search key must be a unique, non-nullable, single-column index which is not offline, is not defined on a non-deterministic or imprecise nonpersisted computed column, and has maximum size of 900 bytes. Choose another index for the full-text key."

I have tried both the PK index and the Unique index. Both indexes are created over a single column (ID) which is an INTEGER, NOT NULL. Both indexes appear to conform to all of the requirements for the KEY INDE but I canot successfully create the Full Text Index.

Select @@v

SQL 2008 Full-Text-Catalog Population Schedule "Repopulate catalog" grayed-out (inactive)


We've recently upgraded our server from SQL 2000 to SQL 2008 and we're having a problem scheduling the recurring repopulation of our full-text search catalogs.

Under the "General" page of the "Full-Text Catalog Properties" window, the "Repopulate catalog" radio button is disabled (grayed out).

Under the "Population Schedule" page  of the "Full-Text Catalog Properties" window, the "Population Type" dropdown contains ONLY "Catalog - optimze".  How do we schedule the full-text catalog repopulation? What setting are we missing?


Full text search not working for pre-existing data on table after installing docx filter.However wor


Hello All,


I have a strange issue. I have pre-existing data in my table with full text index defined along with catalog. I noticed that I did not have the docx filter ,so I installed the filter and performed the steps below. After installing the filter  I added a couple of new records. I noticed that the full text search pulled up the new records matching the criteria but did not return any pre-existing records. Could you please let me know the issue.Please note – currently I am using sql 2008 , but also would like to verify the same in sql 2005 as well.

Also could you please verify the steps below for installation in sql 2008 and sql 2005 and with different architectures (Eg windows 2003/2008, 32bit, 64 bit etc)


This was tested on VM image on 64 bit architecture Windows 200

Enable Full Text Index in VWD 2008 / SQL Server Express 2008


 Hi, I am using VWD 2008 Express and SQL Server 2008 Express. I want to enable full text index in some of my table. How do I do that? I only have  SQL Server Management Studio Express 2008. As far as I know, I cannot use SQL Server Management Studio Express 2008 to update the full text catalog according to : http://msdn.microsoft.com/en-us/library/ms365247.aspx

My tables are also not enable Full Text Search by default. 


 Any help would be very much appreciated!

 Edit 1: Someone had a similar problem to mine on this link: http://forums.asp.net/t/1169961.aspx
I installed the Sql Server 2008 Express with Advance Services and made sure that Full Text functionality is installed. However I don't get a full text menu in SQL Server Management Studio. 

 Edit 2: I uninstall and reinstall SQL Server 2008 Express with Advance Services but still couldn't be able to enable full text index.

 Edit 3: After see this, I guess I have to do it manually then:  http://forums.microsoft.com/MSDN/ShowPost.aspx?siteid=1&PostID=3912985

Can't full text search pdf files


I have a MyDocuments table that has the following columns: ID, Document varchar(max), and DocumentType

I'm only able to get HTML and TXT results from my full text search queries -- but I know that I should be getting PDFs as well.

What am I doing wrong?

FYI: I did install the iFilter.

Full Text Search .


Hi ,

I have around 250 tables and i beleive for each table the full text index/catlog) has to be created. When i write a full text search query say for all the tables what would be the cost(Performance) ???? and i also wanted to know about the performance of these full text Queries in an OLTP database(Transactions mainly)

Regards, Santhosh Hiriyanna

Installing full text search not showing up as an option to install (per advances services installati



Per the following link regarding installation pre-reqs for the adventure works sample databases:


when adding features to an existing sql installation/instance I am not seeing the "Full Text Search" check box when adding features under the Instance Features/Database Engine Services node.

Has anybody else ran into this issue?



Full Text Search Theasarus Help!



I'm trying to use SQL full text search (SQL Server 2008) to match rows of information in two different tables with a cursor. Essentially what it should do is take product "A" and product "B" and see if they're of the same product family.

Example: A = "Windows Server 2003". B= "Windows Server 2008". <--this would be a match.

Example2: A = "Windows 7". B="Windows Server 2008" <--this would NOT be a match. I've constructed a Theasarus and am using the Contrains(FORMSOF(Theasarus,product)) and it appears to work to an extent. However, it is matching "Windows 7" with "Windows Server [edition]" products.  Below is my code and Theasarus.

Thanks for the help!

  • declare @FTSproduct nvarchar(255)
    declare @FTSwrappedProduct nvarchar(255)
    declare @FTSformsOfProduct nvarchar(255)
    declare @TechnologyName nvarchar(255)
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend