Re: Use of Full text Search and relation with Index server for te

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:5ADF12A7-9BC2-4B67-8770-1B37A10C7BBB@xxxxxxxxxxxxxxxx
> 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.
>
>
> "John Kane" wrote:
>
> > 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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> > message news:0A5DCA4D-2220-4A23-A370-E73B9B04CDFE@xxxxxxxxxxxxxxxx
> > > 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.
> > >
> > > "Hilary Cotter" wrote:
> > >
> > > > 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@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in
> > > > message news:6F5693C9-EF81-4624-B4E0-FDD54B85EEBB@xxxxxxxxxxxxxxxx
> > > > > 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.
> > > > >
> > > > > I am totally unawear of Full Text Search of SQL,so please gide me
the
> > same
> > > >
> > > >
> > > >
> >
> >
> >


.

Relevant Pages

  • Design decision
    ... New to indexing service. ... Win 2003 server running .Net web application and SQL ... To search for words in a folder of word documents - there ...
    (microsoft.public.inetserver.indexserver)
  • Re: Use of Full text Search and relation with Index server for te
    ... Can it be possible to exract SQL table contains as search result Using Index ... "John Kane" wrote: ... the Indexing Service (new name for "Index Server" since its was ... > 1) The Indexing Service is used to Full-text Index files on disk. ...
    (microsoft.public.sqlserver.fulltext)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)