Full text-searching, text-indexing

What is these about in SQl Server 2000 and MSDE ?It constructs an index of all the words in the content you are full-text
indexing which is similar to the index you will find at the back of a book.
A full-text query against a word or a phrase will return rows which contain
that word or phrase.
SQL FTS does not ship with MSDE, but is a downloadable component with SQL
Server Express (the SQL 2005 "version"/flavor of MSDE).
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Man Utd" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:ONFN4NFaGHA.4620@.TK2MSFTNGP04.phx.gbl...
> What is these about in SQl Server 2000 and MSDE ?
>|||As we are going to develop a full text-search application using SQL
Server/MSDE.
Is there any startup guide ?
So it seems not simple as:
SELECT *
FROM tlb1
WHERE Field1 like "%smith%"
or Field2 like "%smith%"
or ...
SELECT *
FROM tlb2
WHERE Field1 like "%smith%"
or Field2 like "%smith%"
or ...
.....
because I need to fetch the fields from all tables when the contents of each
table field has a string like "smith".
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:O6XGcaGaGHA.3992@.TK2MSFTNGP05.phx.gbl...
> It constructs an index of all the words in the content you are full-text
> indexing which is similar to the index you will find at the back of a
book.
> A full-text query against a word or a phrase will return rows which
contain
> that word or phrase.
> SQL FTS does not ship with MSDE, but is a downloadable component with SQL
> Server Express (the SQL 2005 "version"/flavor of MSDE).
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Man Utd" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:ONFN4NFaGHA.4620@.TK2MSFTNGP04.phx.gbl...
> > What is these about in SQl Server 2000 and MSDE ?
> >
> >
>|||Is it possible to create a full-text index of several table? From the
example I got I can only create a full-text index for single table.
"Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:On#QVi8cGHA.1204@.TK2MSFTNGP02.phx.gbl...
> As we are going to develop a full text-search application using SQL
> Server/MSDE.
> Is there any startup guide ?
> So it seems not simple as:
> SELECT *
> FROM tlb1
> WHERE Field1 like "%smith%"
> or Field2 like "%smith%"
> or ...
> SELECT *
> FROM tlb2
> WHERE Field1 like "%smith%"
> or Field2 like "%smith%"
> or ...
> .....
> because I need to fetch the fields from all tables when the contents of
each
> table field has a string like "smith".
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:O6XGcaGaGHA.3992@.TK2MSFTNGP05.phx.gbl...
> > It constructs an index of all the words in the content you are full-text
> > indexing which is similar to the index you will find at the back of a
> book.
> > A full-text query against a word or a phrase will return rows which
> contain
> > that word or phrase.
> >
> > SQL FTS does not ship with MSDE, but is a downloadable component with
SQL
> > Server Express (the SQL 2005 "version"/flavor of MSDE).
> >
> > --
> > Hilary Cotter
> > Director of Text Mining and Database Strategy
> > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> >
> > This posting is my own and doesn't necessarily represent RelevantNoise's
> > positions, strategies or opinions.
> >
> > 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
> >
> >
> >
> > "Man Utd" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> > news:ONFN4NFaGHA.4620@.TK2MSFTNGP04.phx.gbl...
> > > What is these about in SQl Server 2000 and MSDE ?
> > >
> > >
> >
> >
>sql

Full text-searching, text-indexing

What is these about in SQl Server 2000 and MSDE ?It constructs an index of all the words in the content you are full-text
indexing which is similar to the index you will find at the back of a book.
A full-text query against a word or a phrase will return rows which contain
that word or phrase.
SQL FTS does not ship with MSDE, but is a downloadable component with SQL
Server Express (the SQL 2005 "version"/flavor of MSDE).
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Man Utd" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:ONFN4NFaGHA.4620@.TK2MSFTNGP04.phx.gbl...
> What is these about in SQl Server 2000 and MSDE ?
>|||As we are going to develop a full text-search application using SQL
Server/MSDE.
Is there any startup guide ?
So it seems not simple as:
SELECT *
FROM tlb1
WHERE Field1 like "%smith%"
or Field2 like "%smith%"
or ...
SELECT *
FROM tlb2
WHERE Field1 like "%smith%"
or Field2 like "%smith%"
or ...
.....
because I need to fetch the fields from all tables when the contents of each
table field has a string like "smith".
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:O6XGcaGaGHA.3992@.TK2MSFTNGP05.phx.gbl...
> It constructs an index of all the words in the content you are full-text
> indexing which is similar to the index you will find at the back of a
book.
> A full-text query against a word or a phrase will return rows which
contain
> that word or phrase.
> SQL FTS does not ship with MSDE, but is a downloadable component with SQL
> Server Express (the SQL 2005 "version"/flavor of MSDE).
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Man Utd" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:ONFN4NFaGHA.4620@.TK2MSFTNGP04.phx.gbl...
>|||Is it possible to create a full-text index of several table? From the
example I got I can only create a full-text index for single table.
"Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:On#QVi8cGHA.1204@.TK2MSFTNGP02.phx.gbl...
> As we are going to develop a full text-search application using SQL
> Server/MSDE.
> Is there any startup guide ?
> So it seems not simple as:
> SELECT *
> FROM tlb1
> WHERE Field1 like "%smith%"
> or Field2 like "%smith%"
> or ...
> SELECT *
> FROM tlb2
> WHERE Field1 like "%smith%"
> or Field2 like "%smith%"
> or ...
> .....
> because I need to fetch the fields from all tables when the contents of
each
> table field has a string like "smith".
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:O6XGcaGaGHA.3992@.TK2MSFTNGP05.phx.gbl...
> book.
> contain
SQL[vbcol=seagreen]
>

Full Text Search service

Hi,
anyone can tell me if whith Msde 2000a (Sp3a) or with Sp4 the full text
search service is supported?
Thanks in advance.
hi,
fc3 wrote:
> Hi,
> anyone can tell me if whith Msde 2000a (Sp3a) or with Sp4 the full
> text search service is supported?
> Thanks in advance.
nope... unfortunately MSDE does not support FullText service
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Grazie.
Many thanks.
"Andrea Montanari" wrote:

> hi,
> fc3 wrote:
> nope... unfortunately MSDE does not support FullText service
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||fc3 wrote:
> Grazie.
> Many thanks.
:D
prego
you are welcome
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply