all groups > sql server full text search > july 2005 >
You're in the

sql server full text search

group:

Use of Full text Search and relation with Index server for textse


Use of Full text Search and relation with Index server for textse Pallavi Kulkarni.
7/20/2005 4:46:31 AM
sql server full text search:
Hello,
I have to implement Search engine for one website,which will be capabale of
finding text from HTML,DOcs,and Db,
For HTML and DOC search I am currently using Index server for FREE TEXT
SEARCH.
Now I need help about how to search text from SQL tables,whether FULL TEXT
will help me,to find contents from table.

Re: Use of Full text Search and relation with Index server for te Pallavi Kulkarni.
7/20/2005 6:09:05 AM
Hell Sir,
Thanks for this...
I even want to know.whether Index server and Free text search using SQL
server are related ..aur both use for same purpose..
Could you plezz tell me URL where i can get procedure to implement Free text
search for my website..in detail..

Thank in advance.

[quoted text, click to view]
Re: Use of Full text Search and relation with Index server for te John Kane
7/20/2005 6:46:44 AM
Pallavi,
Yes, the Indexing Service (new name for "Index Server" since its was
incorporated in the OS starting with Windows 2000 Server) and SQL Server
Full-Text Search (FTS) are related. However, both differ in purpose:

1) The Indexing Service is used to Full-text Index files on disk.
2) SQL Server FTS is used to Full-text Index text and files in a SQL Server
table.

URL for procedure to implement Free Text Search via Indexing Service (using
ASP.NET and VB.NET)
How to use an ASP.NET application to query an Indexing Service catalog by
using Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;820105

URL for procedure to implement Free Text Search via SQL Server Full-text
Search:
Full Text Search using SQL Server 2000/ASP.NET (w/ Tutorial)
http://www.freevbcode.com/ShowCode.asp?ID=4224 and download:
source/full_text_search.zip Unzip the file and review "Tutorial for Full
Text Index.htm" and see "CREATE PROCEDURE freetext_rank_proc" for details.

Hope that helps!
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/


"Pallavi Kulkarni." <PallaviKulkarni@discussions.microsoft.com> wrote in
message news:0A5DCA4D-2220-4A23-A370-E73B9B04CDFE@microsoft.com...
[quoted text, click to view]

Re: Use of Full text Search and relation with Index server for textse Hilary Cotter
7/20/2005 8:34:59 AM
Have a look at this to help you get started.

http://www.indexserverfaq.com/SQLFTIWizard.htm

to query your full text indexed tables have a look at CONTAINS and FREETEXT
in BOL.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Pallavi Kulkarni." <PallaviKulkarni@discussions.microsoft.com> wrote in
message news:6F5693C9-EF81-4624-B4E0-FDD54B85EEBB@microsoft.com...
[quoted text, click to view]

Re: Use of Full text Search and relation with Index server for te Pallavi Kulkarni.
7/20/2005 10:07:01 PM
thanks a lot Sir...I have gone thru the docs...
I have to implement search engine for one website which will exract searched
items from ASPX's,HTML,XLs,DOCs,Db for which I am using Index Server and FTS
SQL server,Reg that I have following query
1] I am not able to exract contents which are binded in server tags (Text
inside asp:Label tag is not searchable) but aspx is accessable...(Eg.If I
search for "AAA" text,so if it is inside HTML tag then that ASPX comes in
search result,but on the other hand if I bind in ASP LAbel tag,then AAA
search will not give that ASPX in result set.)
2] Will it be possible via Full text server to find cotents from multiple
table for one text.
3] Can it be possible to get data of FTS in Dataset.
4] How to combine result of Index server which will be inside Dataset,and
result of FTS so as to display both results on same ASPX Page.


[quoted text, click to view]
Re: Use of Full text Search and relation with Index server for te Pallavi Kulkarni.
7/20/2005 10:42:01 PM
Can it be possible to exract SQL table contains as search result Using Index
Server,??


[quoted text, click to view]
Re: Use of Full text Search and relation with Index server for te Hilary Cotter
7/21/2005 6:10:26 AM
1) you can only index some html tags (i.e. title, Author, custom metatags)
and what is in the body tags. Indexing Services is not able to render the
aspx code.
2) not unless you union all the tables you are interested in
3) through an openquery to a linked server using the MSIDXS provider and
unioning this with your SQL FTS querys
4) See 3

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Pallavi Kulkarni." <PallaviKulkarni@discussions.microsoft.com> wrote in
message news:5ADF12A7-9BC2-4B67-8770-1B37A10C7BBB@microsoft.com...
[quoted text, click to view]

RE: Use of Full text Search and relation with Index server for textse Pallavi Kulkarni.
7/24/2005 11:26:03 PM
Thanks a lot....
Now I am able to display contents from SQL table,
Now Client wants to display corresponding ASPX which displayes searched
contents incase of normal flow,so could you please suggest some scheme via
which I can disply,I got one but dont know whether it is write and how to
implement .The sceme is :

Maintain one table which will store all contents of perticular page,and
then after details of searched element is found out search page for those
details and then pass pageid along with parameters on which the display is
dependent and display page...will it be the feasible soln,or there is some
way by which INDEX server itself will do that..??

[quoted text, click to view]
AddThis Social Bookmark Button