Showing posts with label catalog. Show all posts
Showing posts with label catalog. Show all posts

Sunday, February 26, 2012

Full-text searching

I created a catalog by:
Use Pubs
EXEC sp_fulltext_catalog 'Cat_Test', 'create'
EXEC sp_fulltext_table 'publishers', 'create', 'Cat_Test', 'upkcl_pubind'
EXEC sp_fulltext_column 'publishers','pub_name','add'
EXEC sp_fulltext_column 'publishers','city','add'
EXEC sp_fulltext_column 'publishers','state','add'
EXEC sp_fulltext_table 'publishers','activate'
EXEC sp_fulltext_catalog 'Cat_Test', 'start_full'
EXEC sp_fulltext_table 'publishers','start_change_tracking'
EXEC sp_fulltext_table 'publishers','start_background_updateind
ex'
If I use the SQL
select city
from publishers
where contains (city, '"Paris"')
It return no record.
However, if I use
select *
from publishers
where city = 'Paris'
returned one record.The code you sent is working perfect for me.
Make sure that the Windows account used by the full-text service has
permissions on the SQL Server instance. I have seen that issue a few times
before.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:

> I created a catalog by:
> Use Pubs
> EXEC sp_fulltext_catalog 'Cat_Test', 'create'
> EXEC sp_fulltext_table 'publishers', 'create', 'Cat_Test', 'upkcl_pubind'
> EXEC sp_fulltext_column 'publishers','pub_name','add'
> EXEC sp_fulltext_column 'publishers','city','add'
> EXEC sp_fulltext_column 'publishers','state','add'
> EXEC sp_fulltext_table 'publishers','activate'
> EXEC sp_fulltext_catalog 'Cat_Test', 'start_full'
> EXEC sp_fulltext_table 'publishers','start_change_tracking'
> EXEC sp_fulltext_table 'publishers','start_background_updateind
ex'
> If I use the SQL
> select city
> from publishers
> where contains (city, '"Paris"')
> It return no record.
> However, if I use
> select *
> from publishers
> where city = 'Paris'
> returned one record.
>
>|||Are you saying you can use
select city
from publishers
where contains (city, '"Paris"')
returns a record ?
Can you elaborate what do you mean by
> Make sure that the Windows account used by the full-text service has
> permissions on the SQL Server instance.
I am using Developer Edition.
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:797F3FC7-2D47-4340-9683-CA11235E74E4@.microsoft.com...[vbcol=seagreen]
> The code you sent is working perfect for me.
> Make sure that the Windows account used by the full-text service has
> permissions on the SQL Server instance. I have seen that issue a few times
> before.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
>
'upkcl_pubind'[vbcol=seagreen]|||You better try this
select city
from publishers
where contains (city, 'Paris')
Go to Services on your computer and see which acount your full-text service
is using. The service name could be something like Microsoft Search or SQL
Server FullText Search. Then verify or give permissions to this account on
SQL Server.
I have seen before this service running as Local System. So, in this case NT
AUTHORITY\SYSTEM must be given permissions on the SQL Server instance.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:

> Are you saying you can use
> select city
> from publishers
> where contains (city, '"Paris"')
> returns a record ?
> Can you elaborate what do you mean by
> I am using Developer Edition.
>
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:797F3FC7-2D47-4340-9683-CA11235E74E4@.microsoft.com...
> 'upkcl_pubind'
>
>|||Hi Ben,
Yes, the service is running as Local System.
Can you tell me how do I give permission to the NTAUTHORITY/SYSTEM please ?
Thanks
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:8868199F-1F62-4528-A783-D54A28875697@.microsoft.com...
> You better try this
> select city
> from publishers
> where contains (city, 'Paris')
> Go to Services on your computer and see which acount your full-text
service
> is using. The service name could be something like Microsoft Search or SQL
> Server FullText Search. Then verify or give permissions to this account on
> SQL Server.
> I have seen before this service running as Local System. So, in this case
NT[vbcol=seagreen]
> AUTHORITY\SYSTEM must be given permissions on the SQL Server instance.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
>
times[vbcol=seagreen]|||I checked in EM that the BUILTIN\Administrator has all permissions on all
databases.
And the database roles are public and db_owner.
I tried to add more permission on the role for the databases but got an
error:
"Error 15404: Cannot use the reserved user or role name 'dbo'"
So that I cannot add more permission to the BUILTIN\Administrator.
"Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:uHGuzK7dGHA.3948@.TK2MSFTNGP03.phx.gbl...
> Hi Ben,
> Yes, the service is running as Local System.
> Can you tell me how do I give permission to the NTAUTHORITY/SYSTEM please
?
> Thanks
>
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:8868199F-1F62-4528-A783-D54A28875697@.microsoft.com...
> service
SQL[vbcol=seagreen]
on[vbcol=seagreen]
case[vbcol=seagreen]
> NT
> times
>|||Hi Ben,
I am still in the trouble of not getting the full-text search working.
Could you direct me how do I , as you said, to give permission to my login
account on the SQL Server ?
My situation is:
1) Windows XP
2) Windows login is 'Alan', password 'Alan'
3) SQL Server 2000 Developer edition use Windows authentication
4) Run EM
5) Open QA inside EM
6) Run the T-SQL to create catalog and include tables from pubs database
7) Checked the catalog status is idle in EM and also got no result from the
query using CONTAINS in QA.
8) I had populate the catalog but the status is still idle
I am really worry about because I really need to get that done very soon but
I get stuck here.
Thank you for your time
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:8868199F-1F62-4528-A783-D54A28875697@.microsoft.com...
> You better try this
> select city
> from publishers
> where contains (city, 'Paris')
> Go to Services on your computer and see which acount your full-text
service
> is using. The service name could be something like Microsoft Search or SQL
> Server FullText Search. Then verify or give permissions to this account on
> SQL Server.
> I have seen before this service running as Local System. So, in this case
NT[vbcol=seagreen]
> AUTHORITY\SYSTEM must be given permissions on the SQL Server instance.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
>
times[vbcol=seagreen]

Full-text searching

I created a catalog by:
Use Pubs
EXEC sp_fulltext_catalog 'Cat_Test', 'create'
EXEC sp_fulltext_table 'publishers', 'create', 'Cat_Test', 'upkcl_pubind'
EXEC sp_fulltext_column 'publishers','pub_name','add'
EXEC sp_fulltext_column 'publishers','city','add'
EXEC sp_fulltext_column 'publishers','state','add'
EXEC sp_fulltext_table 'publishers','activate'
EXEC sp_fulltext_catalog 'Cat_Test', 'start_full'
EXEC sp_fulltext_table 'publishers','start_change_tracking'
EXEC sp_fulltext_table 'publishers','start_background_updateindex'
If I use the SQL
select city
from publishers
where contains (city, '"Paris"')
It return no record.
However, if I use
select *
from publishers
where city = 'Paris'
returned one record.The code you sent is working perfect for me.
Make sure that the Windows account used by the full-text service has
permissions on the SQL Server instance. I have seen that issue a few times
before.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:
> I created a catalog by:
> Use Pubs
> EXEC sp_fulltext_catalog 'Cat_Test', 'create'
> EXEC sp_fulltext_table 'publishers', 'create', 'Cat_Test', 'upkcl_pubind'
> EXEC sp_fulltext_column 'publishers','pub_name','add'
> EXEC sp_fulltext_column 'publishers','city','add'
> EXEC sp_fulltext_column 'publishers','state','add'
> EXEC sp_fulltext_table 'publishers','activate'
> EXEC sp_fulltext_catalog 'Cat_Test', 'start_full'
> EXEC sp_fulltext_table 'publishers','start_change_tracking'
> EXEC sp_fulltext_table 'publishers','start_background_updateindex'
> If I use the SQL
> select city
> from publishers
> where contains (city, '"Paris"')
> It return no record.
> However, if I use
> select *
> from publishers
> where city = 'Paris'
> returned one record.
>
>|||Are you saying you can use
select city
from publishers
where contains (city, '"Paris"')
returns a record ?
Can you elaborate what do you mean by
> Make sure that the Windows account used by the full-text service has
> permissions on the SQL Server instance.
I am using Developer Edition.
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:797F3FC7-2D47-4340-9683-CA11235E74E4@.microsoft.com...
> The code you sent is working perfect for me.
> Make sure that the Windows account used by the full-text service has
> permissions on the SQL Server instance. I have seen that issue a few times
> before.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
> > I created a catalog by:
> >
> > Use Pubs
> >
> > EXEC sp_fulltext_catalog 'Cat_Test', 'create'
> >
> > EXEC sp_fulltext_table 'publishers', 'create', 'Cat_Test',
'upkcl_pubind'
> >
> > EXEC sp_fulltext_column 'publishers','pub_name','add'
> >
> > EXEC sp_fulltext_column 'publishers','city','add'
> >
> > EXEC sp_fulltext_column 'publishers','state','add'
> >
> > EXEC sp_fulltext_table 'publishers','activate'
> >
> > EXEC sp_fulltext_catalog 'Cat_Test', 'start_full'
> >
> > EXEC sp_fulltext_table 'publishers','start_change_tracking'
> >
> > EXEC sp_fulltext_table 'publishers','start_background_updateindex'
> >
> > If I use the SQL
> >
> > select city
> > from publishers
> > where contains (city, '"Paris"')
> >
> > It return no record.
> >
> > However, if I use
> >
> > select *
> > from publishers
> > where city = 'Paris'
> >
> > returned one record.
> >
> >
> >
> >|||You better try this
select city
from publishers
where contains (city, 'Paris')
Go to Services on your computer and see which acount your full-text service
is using. The service name could be something like Microsoft Search or SQL
Server FullText Search. Then verify or give permissions to this account on
SQL Server.
I have seen before this service running as Local System. So, in this case NT
AUTHORITY\SYSTEM must be given permissions on the SQL Server instance.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:
> Are you saying you can use
> select city
> from publishers
> where contains (city, '"Paris"')
> returns a record ?
> Can you elaborate what do you mean by
> > Make sure that the Windows account used by the full-text service has
> > permissions on the SQL Server instance.
> I am using Developer Edition.
>
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:797F3FC7-2D47-4340-9683-CA11235E74E4@.microsoft.com...
> >
> > The code you sent is working perfect for me.
> >
> > Make sure that the Windows account used by the full-text service has
> > permissions on the SQL Server instance. I have seen that issue a few times
> > before.
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "Alan" wrote:
> >
> > > I created a catalog by:
> > >
> > > Use Pubs
> > >
> > > EXEC sp_fulltext_catalog 'Cat_Test', 'create'
> > >
> > > EXEC sp_fulltext_table 'publishers', 'create', 'Cat_Test',
> 'upkcl_pubind'
> > >
> > > EXEC sp_fulltext_column 'publishers','pub_name','add'
> > >
> > > EXEC sp_fulltext_column 'publishers','city','add'
> > >
> > > EXEC sp_fulltext_column 'publishers','state','add'
> > >
> > > EXEC sp_fulltext_table 'publishers','activate'
> > >
> > > EXEC sp_fulltext_catalog 'Cat_Test', 'start_full'
> > >
> > > EXEC sp_fulltext_table 'publishers','start_change_tracking'
> > >
> > > EXEC sp_fulltext_table 'publishers','start_background_updateindex'
> > >
> > > If I use the SQL
> > >
> > > select city
> > > from publishers
> > > where contains (city, '"Paris"')
> > >
> > > It return no record.
> > >
> > > However, if I use
> > >
> > > select *
> > > from publishers
> > > where city = 'Paris'
> > >
> > > returned one record.
> > >
> > >
> > >
> > >
>
>|||Hi Ben,
Yes, the service is running as Local System.
Can you tell me how do I give permission to the NTAUTHORITY/SYSTEM please ?
Thanks
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:8868199F-1F62-4528-A783-D54A28875697@.microsoft.com...
> You better try this
> select city
> from publishers
> where contains (city, 'Paris')
> Go to Services on your computer and see which acount your full-text
service
> is using. The service name could be something like Microsoft Search or SQL
> Server FullText Search. Then verify or give permissions to this account on
> SQL Server.
> I have seen before this service running as Local System. So, in this case
NT
> AUTHORITY\SYSTEM must be given permissions on the SQL Server instance.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
> > Are you saying you can use
> > select city
> > from publishers
> > where contains (city, '"Paris"')
> >
> > returns a record ?
> >
> > Can you elaborate what do you mean by
> > > Make sure that the Windows account used by the full-text service has
> > > permissions on the SQL Server instance.
> >
> > I am using Developer Edition.
> >
> >
> > "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> > news:797F3FC7-2D47-4340-9683-CA11235E74E4@.microsoft.com...
> > >
> > > The code you sent is working perfect for me.
> > >
> > > Make sure that the Windows account used by the full-text service has
> > > permissions on the SQL Server instance. I have seen that issue a few
times
> > > before.
> > >
> > > Ben Nevarez, MCDBA, OCP
> > > Database Administrator
> > >
> > >
> > > "Alan" wrote:
> > >
> > > > I created a catalog by:
> > > >
> > > > Use Pubs
> > > >
> > > > EXEC sp_fulltext_catalog 'Cat_Test', 'create'
> > > >
> > > > EXEC sp_fulltext_table 'publishers', 'create', 'Cat_Test',
> > 'upkcl_pubind'
> > > >
> > > > EXEC sp_fulltext_column 'publishers','pub_name','add'
> > > >
> > > > EXEC sp_fulltext_column 'publishers','city','add'
> > > >
> > > > EXEC sp_fulltext_column 'publishers','state','add'
> > > >
> > > > EXEC sp_fulltext_table 'publishers','activate'
> > > >
> > > > EXEC sp_fulltext_catalog 'Cat_Test', 'start_full'
> > > >
> > > > EXEC sp_fulltext_table 'publishers','start_change_tracking'
> > > >
> > > > EXEC sp_fulltext_table 'publishers','start_background_updateindex'
> > > >
> > > > If I use the SQL
> > > >
> > > > select city
> > > > from publishers
> > > > where contains (city, '"Paris"')
> > > >
> > > > It return no record.
> > > >
> > > > However, if I use
> > > >
> > > > select *
> > > > from publishers
> > > > where city = 'Paris'
> > > >
> > > > returned one record.
> > > >
> > > >
> > > >
> > > >
> >
> >
> >|||I checked in EM that the BUILTIN\Administrator has all permissions on all
databases.
And the database roles are public and db_owner.
I tried to add more permission on the role for the databases but got an
error:
"Error 15404: Cannot use the reserved user or role name 'dbo'"
So that I cannot add more permission to the BUILTIN\Administrator.
"Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:uHGuzK7dGHA.3948@.TK2MSFTNGP03.phx.gbl...
> Hi Ben,
> Yes, the service is running as Local System.
> Can you tell me how do I give permission to the NTAUTHORITY/SYSTEM please
?
> Thanks
>
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:8868199F-1F62-4528-A783-D54A28875697@.microsoft.com...
> >
> > You better try this
> > select city
> > from publishers
> > where contains (city, 'Paris')
> >
> > Go to Services on your computer and see which acount your full-text
> service
> > is using. The service name could be something like Microsoft Search or
SQL
> > Server FullText Search. Then verify or give permissions to this account
on
> > SQL Server.
> >
> > I have seen before this service running as Local System. So, in this
case
> NT
> > AUTHORITY\SYSTEM must be given permissions on the SQL Server instance.
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "Alan" wrote:
> >
> > > Are you saying you can use
> > > select city
> > > from publishers
> > > where contains (city, '"Paris"')
> > >
> > > returns a record ?
> > >
> > > Can you elaborate what do you mean by
> > > > Make sure that the Windows account used by the full-text service has
> > > > permissions on the SQL Server instance.
> > >
> > > I am using Developer Edition.
> > >
> > >
> > > "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> > > news:797F3FC7-2D47-4340-9683-CA11235E74E4@.microsoft.com...
> > > >
> > > > The code you sent is working perfect for me.
> > > >
> > > > Make sure that the Windows account used by the full-text service has
> > > > permissions on the SQL Server instance. I have seen that issue a few
> times
> > > > before.
> > > >
> > > > Ben Nevarez, MCDBA, OCP
> > > > Database Administrator
> > > >
> > > >
> > > > "Alan" wrote:
> > > >
> > > > > I created a catalog by:
> > > > >
> > > > > Use Pubs
> > > > >
> > > > > EXEC sp_fulltext_catalog 'Cat_Test', 'create'
> > > > >
> > > > > EXEC sp_fulltext_table 'publishers', 'create', 'Cat_Test',
> > > 'upkcl_pubind'
> > > > >
> > > > > EXEC sp_fulltext_column 'publishers','pub_name','add'
> > > > >
> > > > > EXEC sp_fulltext_column 'publishers','city','add'
> > > > >
> > > > > EXEC sp_fulltext_column 'publishers','state','add'
> > > > >
> > > > > EXEC sp_fulltext_table 'publishers','activate'
> > > > >
> > > > > EXEC sp_fulltext_catalog 'Cat_Test', 'start_full'
> > > > >
> > > > > EXEC sp_fulltext_table 'publishers','start_change_tracking'
> > > > >
> > > > > EXEC sp_fulltext_table 'publishers','start_background_updateindex'
> > > > >
> > > > > If I use the SQL
> > > > >
> > > > > select city
> > > > > from publishers
> > > > > where contains (city, '"Paris"')
> > > > >
> > > > > It return no record.
> > > > >
> > > > > However, if I use
> > > > >
> > > > > select *
> > > > > from publishers
> > > > > where city = 'Paris'
> > > > >
> > > > > returned one record.
> > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>|||Hi Ben,
I am still in the trouble of not getting the full-text search working.
Could you direct me how do I , as you said, to give permission to my login
account on the SQL Server ?
My situation is:
1) Windows XP
2) Windows login is 'Alan', password 'Alan'
3) SQL Server 2000 Developer edition use Windows authentication
4) Run EM
5) Open QA inside EM
6) Run the T-SQL to create catalog and include tables from pubs database
7) Checked the catalog status is idle in EM and also got no result from the
query using CONTAINS in QA.
8) I had populate the catalog but the status is still idle
I am really worry about because I really need to get that done very soon but
I get stuck here.
Thank you for your time
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:8868199F-1F62-4528-A783-D54A28875697@.microsoft.com...
> You better try this
> select city
> from publishers
> where contains (city, 'Paris')
> Go to Services on your computer and see which acount your full-text
service
> is using. The service name could be something like Microsoft Search or SQL
> Server FullText Search. Then verify or give permissions to this account on
> SQL Server.
> I have seen before this service running as Local System. So, in this case
NT
> AUTHORITY\SYSTEM must be given permissions on the SQL Server instance.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Alan" wrote:
> > Are you saying you can use
> > select city
> > from publishers
> > where contains (city, '"Paris"')
> >
> > returns a record ?
> >
> > Can you elaborate what do you mean by
> > > Make sure that the Windows account used by the full-text service has
> > > permissions on the SQL Server instance.
> >
> > I am using Developer Edition.
> >
> >
> > "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> > news:797F3FC7-2D47-4340-9683-CA11235E74E4@.microsoft.com...
> > >
> > > The code you sent is working perfect for me.
> > >
> > > Make sure that the Windows account used by the full-text service has
> > > permissions on the SQL Server instance. I have seen that issue a few
times
> > > before.
> > >
> > > Ben Nevarez, MCDBA, OCP
> > > Database Administrator
> > >
> > >
> > > "Alan" wrote:
> > >
> > > > I created a catalog by:
> > > >
> > > > Use Pubs
> > > >
> > > > EXEC sp_fulltext_catalog 'Cat_Test', 'create'
> > > >
> > > > EXEC sp_fulltext_table 'publishers', 'create', 'Cat_Test',
> > 'upkcl_pubind'
> > > >
> > > > EXEC sp_fulltext_column 'publishers','pub_name','add'
> > > >
> > > > EXEC sp_fulltext_column 'publishers','city','add'
> > > >
> > > > EXEC sp_fulltext_column 'publishers','state','add'
> > > >
> > > > EXEC sp_fulltext_table 'publishers','activate'
> > > >
> > > > EXEC sp_fulltext_catalog 'Cat_Test', 'start_full'
> > > >
> > > > EXEC sp_fulltext_table 'publishers','start_change_tracking'
> > > >
> > > > EXEC sp_fulltext_table 'publishers','start_background_updateindex'
> > > >
> > > > If I use the SQL
> > > >
> > > > select city
> > > > from publishers
> > > > where contains (city, '"Paris"')
> > > >
> > > > It return no record.
> > > >
> > > > However, if I use
> > > >
> > > > select *
> > > > from publishers
> > > > where city = 'Paris'
> > > >
> > > > returned one record.
> > > >
> > > >
> > > >
> > > >
> >
> >
> >

Friday, February 24, 2012

Fulltext Search or Like Search

Hi,
I need to search a Items catalog that has a field that is key word
seperated by commas. Would a fulltext search be more productive than a like
searcn. If the use keys in Bic Black Pens then that is all it should bring
up but if they key in pens it should only get pens. With the like I have been
getting despensers. I don't know exactly how Fulltext search would work for
this.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server-search/200611/1
Hello MattIrwin
Full text would treat words as words and not return misses as in you case.
You can also use full text to use a thesaurus and have much more complicated
searches, i.e. Pen AND NOT Fountain. Which is much more difficult with LIKE
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> Hi,
> I need to search a Items catalog that has a field that is key word
> seperated by commas. Would a fulltext search be more productive than a
> like
> searcn. If the use keys in Bic Black Pens then that is all it should
> bring up but if they key in pens it should only get pens. With the
> like I have been getting despensers. I don't know exactly how Fulltext
> search would work for this.
>
|||Full text for English will break words at white space. So bic black pen
would be broken as three words, bic, black and pen. Dispensers would be
broken as dispensers. In a free text search this would match with
dispensers, dispenser, dispenser's, and dispensers.
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
"MattIrwin via droptable.com" <u28166@.uwe> wrote in message
news:6926b9c20e067@.uwe...
> Hi,
> I need to search a Items catalog that has a field that is key word
> seperated by commas. Would a fulltext search be more productive than a
> like
> searcn. If the use keys in Bic Black Pens then that is all it should
> bring
> up but if they key in pens it should only get pens. With the like I have
> been
> getting despensers. I don't know exactly how Fulltext search would work
> for
> this.
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums.aspx/sql-server-search/200611/1
>
|||You need to use a word breaker which breaks the words in the form you want,
Greek I take it. Otherwise I think like is your best bet.
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
"Allan Ebdrup" <ebdrup@.noemail.noemail> wrote in message
news:%23aVerjWNHHA.3424@.TK2MSFTNGP02.phx.gbl...
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:uo8ZEAyBHHA.4892@.TK2MSFTNGP04.phx.gbl...
> I would like to do the opposite.
> When searching for "pdagog" I also want to return results that contain
> "dagplejepdagog" or "pdagogmedhjlper" is ther no other way to
> accomplish this than using LIKE '%pdagog%'.
> Performance using LIKE is very poor, how do I improve performance?
> Kind Regards,
> Allan Ebdrup
>
|||Allan wrote on Thu, 11 Jan 2007 11:11:51 +0100:

> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message news:uo8ZEAyBHHA.4892@.TK2MSFTNGP04.phx.gbl...
> I would like to do the opposite.
> When searching for "pdagog" I also want to return results that contain
> "dagplejepdagog" or "pdagogmedhjlper" is ther no other way to
> accomplish this than using LIKE '%pdagog%'.
> Performance using LIKE is very poor, how do I improve performance?
The second example is already possible:
SELECT * FROM Table WHERE CONTAINS(*,'pdagog*')
However, the first example isn't. As Hilary has pointed out, there may be a
language dependent wordbreaker that will split the words as you require.
Another option, if you don't mind increasing the storage requirements, is to
index on a reversed version of the data too. Store a copy of the data in
another column in reverse order, such as
KEY Word RWord
1 dagplejepdagog gogadpejelpgad
and create the FTI on both Word and RWord, then you could use:
SELECT * FROM Table WHERE CONTAINS(*,'pdagog* or gogadp*')
However, this won't work when the term you are searching for is in the
middle of a word.
Dan
|||You could be correct here, my knowledge of these languages is not great. The
ligature or digraph commonly occurs in Greek words transliterated into
English, but these do appear more German or Scandinavian.
You might want to check out this document for more info.
http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/
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
"tbh" <femdev@.newsgroups.nospam> wrote in message
news:%23rGPgouOHHA.3544@.TK2MSFTNGP03.phx.gbl...
> "Greek"? looks a bit more like a scandinavian language, doesn't it?
> i think Allan is looking for inflectional forms or compound words
> containing a stem-word in question. i'm interested too (in my case for
> German).
> can anyone point us to good documentation on which languages are supported
> and other details? there is some info here:
> http://msdn2.microsoft.com/en-US/library/ms142507.aspx
> but i would want to learn more.
> cheers,
> Tim Hanson
>

Full-Text search indexing HTML content

I've been quite busy these days looking up which was the best way to create
a full-text search catalog for a field composed entirely of HTML content, a
nd I found out that the best way to handle it, so it could ignore HTML tags
as the search was performed, was to make the column an Image-type field, and
associate a file type in a separate column.
I developed a small application that read each of the text field entries, co
nverted it to a byte[] variable using the UnicodeEncoding class (and it's Ge
tString and GetBytes methods) and saved the resulting byte array as a binary
file in the new image field. I even tested how the field data would fare in
a physical file, by using a FileStream to write the Byte[] data on several
different records.
So far, so good. It all seemed to be working. The problem is that after I bu
ild up the full-text catalog (using the wizard, and specifying the file type
field related to the "image" field where the HTML file is stored), I get no
resulting records whenever I perform a query using either CONTAINS or FREET
EXT. Such queries worked just fine when the field was a text field instead o
f an image field, so I'm guessing something went wrong either on the data co
nversion, or on the catalog building process.
Anyone has any ideas?On Wed, 23 Nov 2005 16:45:54 -0600, bacusgod wrote:
(snip)
>Anyone has any ideas?
Hi bacusgod,
You might want to try reposting this in the group where the full text
experts hang out: microsoft.public.sqlserver.fulltext
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

Sunday, February 19, 2012

Full-text search - catalog refuses to populate

Hello

I'm trying to get full-text searching to work on SQL Server 2000 (with SP3 installed).

I have a table containing many text fields that I want to search and so far have successfully gone through the "Full-Text wizard" selecting the text fields from the table I want as searchable. I then try and start full population of the catalog but its always remains zero in size when I check its properties. Hence when I try a query like:

SELECT Name FROM tblTextDocs WHERE CONTAINS(mainbody, 'find this')

It results in the error message:

Server: Msg 7619, Level 16, State 1, Line 1
Execution of a full-text operation failed. The catalog does not exist or is currently unavailable. Please retry the action again later and if this symptom persists, contact the system administrator.

It would appear that the catalog simply refuses to populate. I've tried starting population via Enterprise Manager and also by doing sp_fulltext_catalog 'MyCatalog', 'start_full'. The Full-text support service says it is running correctly and no other problems with the server have been experienced.

Any suggestions would be much appreciated.

Regards

SamBy the "Full Text Support Service" do you mean the "Microsoft Search" service?|||Originally posted by MCrowley
By the "Full Text Support Service" do you mean the "Microsoft Search" service?

Yes - the Microsoft Search service. I have no problems in stopping/starting it too.|||This error might occur if changing SQL Server Account to Non-Admin for Full-Text Search Makes Existing Catalogs Unusable.

To access existing full-text search catalogs, rebuild and repopulate them. The existing catalogs can also be accessed by switching back to an administrator account.

FullText Search

I have create a table called tblcatalog with colums id(identity,primary key) and contents(varchar(100))

I have then created a full text catalog on that table and populated it.

Then i wrote the following query
"select contents from tblcatalog where contains(contents,'sample data')"
It is fetching 0 records even though u have 5 records with entries "sample data"

Can anyone tell me the solution immediately

bye
shankyImmediately? Have you tried everything you could think of before asking for help? It'll take me 20 minutes or so to setup FullText Search, and will take you probably much less to experiment with it.|||when you say you populated it did you create an initial full population?|||Forgive me if this is basic to you. Just trying to be thorough. :)
In Enterprise Manager, right click on your table. Choose 'Full Text Index Table' (MS Search service must be started for this to appear.) Choose 'Start full population.' Rerun your query. If it works, you must not have really done a full population yet. In that case you may want to set up incremental or full populations using the 'Schedules..' option on the same context menu...
If not, I have no clue what the problem is! :)

Full-text query failed because full-text catalog 'SIMCatalog' is not yet ready for queri

I have a server (W2k3) in wich i use arabic, french and english fulltext.
The arabic and french fulltext are correct but the english fulltext query
shows the following error :
Full-text query failed because full-text catalog 'SIMCatalog' is not yet
ready for queries.
Nb : SIMCatalog is my catalog fulltext for the three langages
Any help please
Chaieb,
Most likely your FT Catalog (SIMCatalog) need to be "populated" either via
the Enterprise Manager or via the following T-SQL code:
EXEC sp_fulltext_catalog 'SIMCatalog', 'start_full'
The above code runs a "Full Population" on your FT Catalog SIMCatalog.
Depending upon the size (number of row) of your FT-enable table, this may
take some time to complete. You can monitor this via the Enterprise Manager
under the Full Text Catalog icon.
Regards,
John
"Chaieb" <h.chaieb@.archimed.fr> wrote in message
news:OJnl2Gc4EHA.2316@.TK2MSFTNGP15.phx.gbl...
> I have a server (W2k3) in wich i use arabic, french and english fulltext.
> The arabic and french fulltext are correct but the english fulltext query
> shows the following error :
> Full-text query failed because full-text catalog 'SIMCatalog' is not yet
> ready for queries.
>
> Nb : SIMCatalog is my catalog fulltext for the three langages
>
> Any help please
>
>