Thesaurus Support In SQL Server Full Text Service

May 20, 2006

Hi,
 
I€™ve been trying to add keywords to the thesaurus used for SQL Server 2005 Full Text services but do not seems to get any improved results.
For example, I have a catalogue of article titles which contains titles such as €˜CRM€™ and then some others use the words €˜Customer Relationship Management€™, the ideal solution I would have thought was SQL Servers thesaurus support, I€™ve been though and added the values:
 
<expansion>
       <sub>customer relationship management</sub>
       <sub>crm</sub>
 </expansion>
 
to the txGlobal.xml file in the SQL Servers FTData directory, I then amended by test query to use this clause:
FORMSOF(THESAURUS,"CRM")
The idea being that when I search for CRM it will bring back articles with Customer Relationship Management also. However I€™m just getting results for the same results as for the word 'CRM' and no expansion is taking place it would seem.
 
Would anyone be able to clarify what the best approach to making this work would be:

Do I need to restart the SQL Server FullText service after making any changes to the XML files?
(Done this, no sucess)


Do I need to restart the SQL Server service after making any changes to the XML files?
(Done this, no sucess)

Do you need to re-populate the full text catalogues after making a change the XML files?
(Done this, no sucess)
 
If this syntax correct when trying to utilise the thesaurus?
CONTAINSTABLE (Article_Metadata, *, €˜FORMSOF(THESAURUS,"CRM")€™ )
(It doesn;t give any errors, just no improved results over:
CONTAINSTABLE (Article_Metadata, *, €˜"CRM"€™ )
 
 
Any help would be appreciated.
 
Thanks
Ed
 

View 3 Replies


ADVERTISEMENT

SQL Server 2005 Full-Text Thesaurus File

Aug 8, 2007

Hi! I am moving this from the Transact SQL forum as I am not getting a reply. Hope it's OK!
Hello: I have successfully enabled SQL Server 2005 Full Text (MSFTESQL) on my database, created the FT Catalog in Storage, and defined a FT Index for a table ( 1 table for testing).

I have also created an expansion and replacement entry in the Thesaurus (tsENU.xml) and removed the comments. I have restarted the server and the FTS Service, In addition, (per your comments to another user) I have used sqlcmd to confirm my default language of 1033.

I am unable to get any results from the Thesaurus file. I am able to run queries against the index using CONTAINS and FREETEXT. I get results - however I only get the same thing I would get from the CONTAINS portion of the query.
Also ..SQLSERVER2995MSFTEUser$.. has permission on the FTData folder.

// This query //

SELECT name, description FROM table
WHERE CONTAINS(description, ' FORMSOF(THESAURUS, blender) ')

// on this Thesaurus located in this C: folder MSSQL.1MSSQLFTData sENU.xml //

<XML ID="Microsoft Search Thesaurus">
<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics = false/>
<case caseflag="false"></case>
<expansion>
<sub>blender</sub>
<sub>chopper</sub>
<sub>grinder</sub>
<sub>food processor</sub>
</expansion>
</thesaurus>
</XML>

// returns this //

A search for blender returns all strings with the exact word blender in them - not even any plural forms. A search for blend or grind returns nothing. FREETEXT does a little better returning blender, blenders, blending. Still no grind,chop, or food process.

Appreciate your help, Thank you.

View 1 Replies View Related

Need Help On Full-Text Search Thesaurus

Aug 13, 2007

Hello: Please let me know if another forum is a better place to post! I have successfully enabled SQL Server 2005 Full Text (MSFTESQL) on my database, created the FT Catalog in Storage, and defined a FT Index for a table ( 1 table for testing).

I have also created an expansion and replacement entry in the Thesaurus (tsENU.xml) and removed the comments. I have restarted the server and the FTS Service, In addition, (per your comments to another user) I have used sqlcmd to confirm my default language of 1033.

I am unable to get any results from the Thesaurus file. I am able to run queries against the index using CONTAINS and FREETEXT. I get results - however I only get the same thing I would get from the CONTAINS portion of the query.
Also ..SQLSERVER2995MSFTEUser$.. has permission on the FTData folder.

// This query //

SELECT name, description FROM table
WHERE CONTAINS(description, ' FORMSOF(THESAURUS, blender) ')

// on this Thesaurus located in this C: folder MSSQL.1MSSQLFTData sENU.xml //

<XML ID="Microsoft Search Thesaurus">
<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics = false/>
<case caseflag="false"></case>
<expansion>
<sub>blender</sub>
<sub>chopper</sub>
<sub>grinder</sub>
<sub>food processor</sub>
</expansion>
</thesaurus>
</XML>

// returns this //

A search for blender returns all strings with the exact word blender in them - not even any plural forms. A search for blend or grind returns nothing. FREETEXT does a little better returning blender, blenders, blending. Still no grind,chop, or food process.

Appreciate your help, Thank you.

View 7 Replies View Related

Problem With Thesaurus In Full-Text Search

Aug 26, 2007

I am trying to get the full-text search thesaurus to work in Sql
Server 2005 Express edition.  I live in the USA so I assume the
tx.ENU.xml is the appropriate file to modify.  I used Notepad to
modify the tx.ENU.xml file as follows:<XML ID="Microsoft Search Thesaurus">

    <thesaurus xmlns="x-schema:tsSchema.xml">
    <diacritics_sensitive>0</diacritics_sensitive>
        <expansion>
            <sub>littre</sub>
            <sub>leydig</sub>
        </expansion>
        <replacement>
            <pat>NT5</pat>
            <pat>W2K</pat>
            <sub>Windows 2000</sub>
        </replacement>
        <expansion>
            <sub>run</sub>
            <sub>jog</sub>
        </expansion>
    </thesaurus>

</XML> I closed Management Studio and reopened to allow MSFTESQL service to restart. Then I ran these queries:SELECT FullDocNo
FROM FullDocuments
WHERE CONTAINS(SectionText, 'littre')    *** returned 3 rows ***SELECT FullDocNo
FROM FullDocuments
WHERE CONTAINS(SectionText, 'leydig')  *** returned 169 rows ***SELECT FullDocNo
FROM FullDocuments
WHERE CONTAINS(SectionText, ' FORMSOF(THESAURUS, littre) ')   *** returned 6 rows ***
Thus the Thesaurus does not seem to be working since it should
have returned at least 169 rows.  I rebooted my entire system to
make sure Sql Server is starting fresh.  Any help in sorting this out will be greatly appreciated.    

View 1 Replies View Related

Full Text Thesaurus Of People Names

Nov 13, 2007



Does anyone know where I can get a Thesaurus (or list) of People's Names and their relationships?

For Example:

Bill = Billy = Billie = Will = Willie = William

Sue = Susie = Susan = Suzanne



I can build the needed xml file to become a Thesaurus for MSSQL Full Text Searching. But I can't find a list of related people names anywhere.

Any help would be great! Thanks!


Lyam

View 3 Replies View Related

How Many Full-text Catalogs Does SQL Server 2005 Support

Jan 21, 2007

SQL Server 2000 is pretty well documented with the limit of 256 (see http://msdn2.microsoft.com/en-us/library/aa214780(SQL.80).aspx) but I can find no documentation anywhere that discusses the limit on SQL Server 2005.

Is there one ?

Please help !



Thanks

View 3 Replies View Related

SQL Server 2008 :: Startup Without Full-Text Service

Feb 9, 2015

I am running SQL 2008 R2. I have SQL Full-Text Search installed (part of a standard Automated build) - but disabled and switched-off as the applications don't need it. However as a result I get SQL Server error 9954:

SQL Server failed to communicate with filter daemon launch service (Windows error: Windows Error: hr = 0x80070422(failed to retrieve text for this error)). Full-Text filter daemon process failed to start. Full-text search functionality will not be available.

appear in the event / error logs everytime I start SQL server. Is it possible to suppress this error (other than by starting the SQL Full-text service) ...

View 0 Replies View Related

Error: SQL Server Failed To Communicate With Full-Text Service

Apr 9, 2007

Hello,
I've enabled full-text indexing on one of my tables, and the following query used to work:
SELECT *
FROM TempAttachment
WHERE CONTAINS(attachment, 'text')


However, now I get the following error:
Msg 9955, Level 16, State 1, Line 1
SQL server failed to communicate with Full-Text Service (msftesql). The system administrator must make sure that same service account is used for both services and the service account has the permission to auto start the full-text service.


I've checked the configuration and verified that both accounts are the same. I've restarted the services, and tried rebooting, and still no luck. I did a search on this error, and found this page from MSDN, which doesn't help me much: http://msdn2.microsoft.com/en-us/library/aa337365.aspx.

Has anybody come across this before? Any help would be greatly appreciated!

View 3 Replies View Related

Docx, Xlsx, Pptx, Xps Support In Full-text Search (FTS)

Jul 2, 2007

Hello,



Are there any information about FTS support to Office 2007 new document format, like docx, xlsx, pptx, xps etc ?



Regards,

View 4 Replies View Related

SQL Server 2012 :: Full-text Filter Daemon Service Error Log

Sep 24, 2014

is there a way to turn off or reduce the logfiles of the MSSQL Full-text Filter Daemon Service?

The entries are very useless and on server with many databases and many fullindex tables it is very inefficient to write all these files (no SSD).

(SQL Server 2012 Express)

View 0 Replies View Related

Equivalent Of SQL Server 2000 Full-text Search Service In SQL 2005?

Mar 29, 2006

What is the equivalent of the SQL Server 2000 Full-Text Search Service in SQL 2005?

I need to know cos i got a forum app implementing this in SQL 2000 but my company is using SQL 2005 Enterprise.

 cos i cannot find this option in sql 2005.....

View 1 Replies View Related

Thesaurus Full Test Search

Oct 5, 2006

Dear All,

I am not able to let thesaurus in SQL Server 2005 works.

My full indexed table has 4 records as follows:

tony

roby

mary

antony

The following is my tsENU.xml file:


<XML ID="Microsoft Search Thesaurus">
<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics = false/>
<expansion>
<sub>Tony</sub>
<sub>Roby</sub>
<sub>Mary</sub>
</expansion>
</thesaurus>
</XML>

After I execute the following query:

SELECT * FROM Person WHERE CONTAINS(*,'FORMSOF(Thesaurus,"Tony")')

the result is only the record containing 'Tony' but I need Tony, Roby and Mary to be treated as synonimus and for that reason the result should be the 3 records containing all the 3 names.

Which is my mistake?

thanks and regards

Buzz

View 19 Replies View Related

Full-text Service Problem

Jul 17, 2000

Recently we have changed ISP and it seems like our SQL server is having problem starting the service for the Full-Text Service. It keeps saying that the account information is not mapped to the Security Identification Data. So, I tried reinstalling the FTS but it says that the FTS component already exists. What seems to be the problem here. I really need to get this service started....

View 1 Replies View Related

How To Install Full Text Search Service?

Jun 5, 2005

I'm running sql server on XP at the moment. I want to make use of
procedures like FREETEXTABLE and CONTAINS for my local site search
engine so I need to have the full text search service installed. The
problem is that when I want to add this component by trying to use the
sql server standard edition cd the option that says 'Upgrade,remove, or
add components to an existing instance of sql server' is grayed out,
meaning I can't pick this option. What must I do to get this working
since the only available option is to insall a new instance of sql
server or client tools? Need help A.S.A.P

View 2 Replies View Related

Full-Text Indexing And Service Packs

May 3, 2004

I have SQL Server 7.0 installed in a Fail-over cluster and currently, Full-text indexing is not installed, since our full-text index resides on a different physical server. In an attempt to consolidate our servers I am looking at installing full-text indexing on our cluster. I understand that there will probably be issues getting the Full-text indexing service to fail-over, but I'm not too concerned with that.

What I am concerned with, is, will I need to re-install the latest SQL Server 7.0 service pack? Does anyone know of any security holes with an un-patched version of the full-text indexing service?

Any advice on this situation is greatly appreciated. Thanks!

View 1 Replies View Related

Full-Text Search - Service Not Responding

Sep 17, 2007

Hi all

I've just had my admin guy start the Full-Text Search service (under Support Services) for a server here. Actually he did it a couple of hours ago. I've checked his computer and the icon shows "started" (ie green traffic light).

From my Enterprise manager, the Full-Text Search icon is still showing "stop" ie red traffic light. Yes, in case you are wondering, I've refreshed, closed and reopened Enterprise manager, and waited quite a while, but my code is definitely still failing on this. Identical code on an identical recordset in another server (which has the full-text icon "green") works fine.

I've already set full-text for the catalog and
SELECT fulltextserviceproperty('IsFulltextInstalled')
returns 1 for this catalog.

My quetion is: does enabling Full-Text Searching require a Server restart, or is there something else I can try first?

Thanks in advance

--
I hope that when I die someone will say of me "That guy sure owed me a lot of money"

View 20 Replies View Related

Configuring The Full-Text Search Service On MSDE

Dec 3, 2004

Can anyone tell if MSDE has the full-text service available and if so how to set it up?

Thanks,
Ralph

View 1 Replies View Related

Msg 7619 Full-text Query Failed. Service Is Not Running.

Mar 5, 2007

I am getting following error when query using a full-text index:
 
select *
from workitemlongtexts
where Contains(words, 'test');
 
==error message==
Msg 7619, Level 16, State 1, Line 1
The execution of a full-text query failed. "Service is not running."
 
I have verified that
1. msftesql service is running,
2. I even rebuilt the full-text index and it didn't help
3. my full-text crawl job is running fine
4. my DB is full-text enabled
 
Can someone explain what "Service" the error refers to? I am using SQL 2005 Ent SP1.

View 1 Replies View Related

SQL 2012 :: Full Text Engine Service In Windows Clustered Environments

May 27, 2014

In SQL Server 2005, the SQL Server full text engine (i.e., Microsoft Full Text Filter Daemon Launcher windows service) was installed as a Generic Service cluster resource in a Windows clustered environment.

However, in SQL Server 2012, the full text engine is not appearing as a "resource" within "Failover Cluster Manager" after installation. Do we need to manually configure the full text engine as a Failover Cluster Manager "resource" for SQL 2012? Or is this not necessary? If it needs to be configured, how do you go about doing it (i.e., what resource dependencies would you setup, etc.)

View 0 Replies View Related

How Can I Include Full Text Search Service In My Program Setup Silently?

Mar 18, 2007

heloo..

if I want to use full text search in my program, can I include Full Text Search service in my program setup silently in the same way as including SQL Express and .Net Framework to the setup project, Or I have to Install MS Sql Server 2005 on my customer computer?

View 1 Replies View Related

SP2 Fails On Cluster - Domain Group Cannot Be Validated For The Service Full-Text Search

Jul 10, 2007

Greetings,

I'm totally stuck on this issue and would really appreciate any advice. Here's what's going on...

I'm trying to install SP2 on a SQL 2005 Std x64 cluster and all the components upgrade except the DB Engine, which fails with this error saying the domain group (not the service account) could not be validated for the full-text search service.

I've rebooted both nodes. I've verified that the domain group exists. I even removed the full text search component and I still get the same error.

I've reviewed this: http://support.microsoft.com/kb/915846
But the ftsgroup registry value mentioned does not exists. I assume it only shows up after sp2 is installed.

Interestingly, I couldn't uninstall full-text search unless I passed the FTSCLUSTERGROUP parameter to the setup.exe command line remove command.

The OS is Windows Server 2003 Ent x64 SP2. Not a domain controller. I'm upgrading from the RTM version of SQL Server.

I've posted the relevant parts of the summary and log files below.

Thanks in advance for any ideas!

- Chris

-------------------------------------

Summary.txt
==========

Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 28130
Error Description : MSP Error: 28130 A domain group is missing for one or more services. To install SQL Server 2005 as a failover cluster, domain groups must be specified for all the clustered services being installed .To proceed, enter the missing domain group information.
The domain group cannot be validated for the service Full-Text Search.



sqlrun_sql.msp.log
===================

<Func Name='GetServiceAccountProperty'>
<Func Name='GetServiceAccountProperty'>
<Func Name='GetServiceAccountProperty'>
Loaded DLL:
C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll
Version:
2005.90.3042.0

Failed to validate group name for FTSCLUSTERGROUP. Error 87
Error Code: 0x80070057 (87)
Windows Error Text: The parameter is incorrect.
Source File Name: sqlcadomaingroupdialog.cpp
Compiler Timestamp: Sat Oct 7 09:43:40 2006
Function Name: validateSetDomainGroups
Source Line Number: 484

MSI (s) (A8!98) [12:17:17:610]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:610]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A8!98) [12:17:17:610]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:626]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:626]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A8!98) [12:17:17:626]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:626]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A8!98) [12:17:17:626]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:626]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 87
MSI (s) (A8!98) [12:17:17:626]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:626]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A8!98) [12:17:17:642]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:642]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:642]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A8!98) [12:17:17:642]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:642]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A8!98) [12:17:17:642]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:642]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A8!98) [12:17:17:642]: Product: Microsoft SQL Server 2005 (64-bit) -- Error 28130. A domain group is missing for one or more services. To install SQL Server 2005 as a failover cluster, domain groups must be specified for all the clustered services being installed .To proceed, enter the missing domain group information.
The domain group cannot be validated for the service Full-Text Search.

Error 28130. A domain group is missing for one or more services. To install SQL Server 2005 as a failover cluster, domain groups must be specified for all the clustered services being installed .To proceed, enter the missing domain group information.
The domain group cannot be validated for the service Full-Text Search.
<EndFunc Name='LaunchFunction' Return='87' GetLastError='0'>
MSI (s) (A88) [12:17:17:642]: Transforming table InstallExecuteSequence.
MSI (s) (A88) [12:17:17:642]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (A88) [12:17:17:658]: Transforming table InstallExecuteSequence.
MSI (s) (A88) [12:17:17:658]: Transforming table InstallExecuteSequence.
MSI (s) (A88) [12:17:17:658]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (A88) [12:17:17:658]: Transforming table InstallExecuteSequence.
MSI (s) (A88) [12:17:17:658]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (A88) [12:17:17:658]: Transforming table InstallExecuteSequence.
MSI (s) (A88) [12:17:17:658]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
Action ended 12:17:17: Validate_ServiceAccounts.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B. Return value 3.
Action ended 12:17:17: INSTALL. Return value 3.
Property(S): ProductCode = {26F1A218-3158-4107-B3A6-37FD61CEE969}
Property(S): ProductLanguage = 1033
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductVersion = 9.2.3042.00

View 2 Replies View Related

Why My Query Is Slow When I Execute Full Text Search Service For Firts Time

Dec 18, 2007

first sorry my english,

when i execute a query for the first time whith full text service from visual studio, show me the error 'server not responding' and when i execute this query for second time works perfectly.

View 1 Replies View Related

SQL Server 2000 Full Text Search (extract Pieces Of Text)

Sep 12, 2007

Hello everyone !
I want to perform Full Text Search with SQL Server 2000. My documents (.doc, .xls, .txt, .pdf) are stored in a SQL Server field which is binary (the type of the column is image).
I would like to know, how you can extract pieces of text from the documents.
Example:
I have a ASPX page with codebehind in C# making the search in a table in SQL server that is full text indexed.
I make a search looking for the word "peace", than SQL server will take care about the search and return it to me the rows that match with that. But also I'd like to extract the 50 characters before and after where sql server found the word "peace" to show in the result page.
Does anyone has any idea how to work around it ?
 Best regards.
Yannick

View 5 Replies View Related

Transact SQL :: Server Text Field Not Returning Full Text

Apr 21, 2015

I have a column in a table that has a type TEXT,when I pull the length of a row it returns 88222 but when I select from that column it dows not show all the text in the result set.

View 3 Replies View Related

Dose SQL Server Integration Service Support Farsi (Persian) Language?

Mar 31, 2008


Dose SQL Server Integration Service support Farsi (Persian) language?

I passed a column of a Farsi text database to Term Extraction component put it didn't send anything to output (destination).

I even use CodePageConvert (http://www.microsoft.com/downloads/details.aspx?FamilyID=9E56417E-23D1-4FD3-8D6D-61314FAA2DE3&displaylang=en) between Source and Term Extraction, it seems that it converted the text but still nothing comes from the Term Extraction.

Sample input for Term Extraction component:
به بوی ناÙ?Ù‡€ŒØ§ÛŒ کاخر صبا زان طره بگشاید
ز تاب جعد مشکینش Ú†Ù‡ خون اÙ?تاد در دل€ŒÙ‡Ø§
مرا در منزل جانان چه امن عیش چون هر دم
جرس Ù?ریاد Ù…ÛŒ€ŒØ¯Ø§Ø±Ø¯ Ú©Ù‡ بربندید محمل€ŒÙ‡Ø§

Thank you,
Babak

View 1 Replies View Related

SQL Server DB Full Text Search

Nov 6, 2004

Where do I find and enable full text search in sql server db?

I have hunted, and hunted, and stumbled, and looked with no luck.

Should it have been installed during set up?

Thanks all,

Zath

View 1 Replies View Related

SQl Server Full Text Search

Jul 19, 2005

I have a server that has windows 2000 with Sql Server Enterprise edition sp3 installed and we are currently using the full text catalogs. I have another server that we have are trying to use the full text catalogs and it does not populate the catalog. I have check the microsoft search service to make sure it is logged in the same. I have gone through and recreated the catalogs twice and they will not populate. Can anyone give me any suggestion of things I can look for, Please ??

View 12 Replies View Related

After Full SQL Server 2005 Install SSIS Is Still Not A Service On The Machine?

Aug 5, 2006

I have done a full Sql Server install on a server and the SSIS service is not available. Normally when I load Sql Server I get €œSQL Server Integration Services" as a service that I can start. On this machine it is not listed after the install. I don't get any errors through out the install.

Please Help!

Steve

View 1 Replies View Related

Full-text Indexing In SQL Server 2005

Jan 5, 2008

in object explorer ,do right-click on database and is selecting preoperties and is selecting "files" page "use full-text indexing" ckeck box is disable.
how can enabled this check box?
thanks , mohsen

View 1 Replies View Related

Microsoft Full-Text Engine For SQL Server

Apr 13, 2008

Hello !
How can I install on  Microsoft SQL Server Express 2005   Full-Text Search Engine ?
I tried to create a full_text_catalog with SQL Server Management Studio Express and I get an error.
Msg 7609, Level 17, State 100, Line 2
Full-Text Search is not installed, or a full-text component cannot be loaded.
 

View 1 Replies View Related

Sql Server: Msg 7607 - Full Text Search

May 30, 2006

hi,

i am getting the above error message when trying to do full text search with containstable on a single table.

i am dynamically creating the search querry condition and some times its even having 18 times "AND" OR "AND NOT" in the search condition.

i have read in MS bug list that there is a limitation of length of the search string while doing FTsearch. it said that its been fixed in SP3 of sql server 2000.

But i am still getting the error 7607 even after installing SP3 on my server.

need advise on resolving this issue..

prad

View 3 Replies View Related

Full Text Indexing Feature Of SQL Server .

Mar 9, 2004

I am using the full text indexing feature of SQL Server .

I have indexed two text fields in the Content table and two other text fields in the ContentDetail table

The select queries are shown below for the two seperate calls.

I want to be able to show the results based on the rank ( The column that has the best match for the searched key ).

Since I am getting two different RANK arrays from the two calls, can i resort them in the code to get the new rank order to show the results in the screen



SELECT KEY_TBL.RANK,FT_TBL.Description, FT_TBL.Title
FROM Content AS FT_TBL
INNER JOIN
CONTAINSTABLE( Content, * ,
'ISABOUT (Cancer weight(1),Survivor weight(1), Shared weight(1), Story weight(1))' ) AS KEY_TBL
ON FT_TBL.ContentID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESC


SELECT KEY_TBL.RANK,FT_TBL.Description, FT_TBL.SubTitle
FROM ContentDetail AS FT_TBL
INNER JOIN
CONTAINSTABLE( ContentDetail, * ,
'ISABOUT (Cancer weight(1),Survivor weight(1), Shared weight(1), Story weight(1))' ) AS KEY_TBL
ON FT_TBL.ContentDetailID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESC

View 2 Replies View Related

Full-text Allowed In SQL Server 2005

Apr 8, 2007

Hi,

I am putting this question here but I am not limiting it to sql server 2005 express edition.

I am developing an app on a local machine (winxp with sql server 2000 personal edition) however I came to find out that full-text does not work in this setup unless I use a server type machine.

This fouls up my development somewhat and I would like to know if there is
a) a work around for my sql server 200 setup
b) does full-text serach work in sql server 2005 express edition which I have installed on my PC ?

Thanks for any input on this issue.

Tuka

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved