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

Full Text Repair

We had a customer request a full text installation after
the application of SP4 and the slammer hotfix. It throws
an error that refers to a re-installation of SP4, which
will not work with any hot fixes applied after the fact.
Does anyone have a different route to follow that
uninstall the hotfix, then reapply the SP4, and then
reapply the hot fix?
Thanks in advance for any information.
Emil
what is the exact error message you are getting?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Emil" <emilcaruthers@.hotmail.com> wrote in message
news:698301c4758b$4e941cd0$a301280a@.phx.gbl...
> We had a customer request a full text installation after
> the application of SP4 and the slammer hotfix. It throws
> an error that refers to a re-installation of SP4, which
> will not work with any hot fixes applied after the fact.
> Does anyone have a different route to follow that
> uninstall the hotfix, then reapply the SP4, and then
> reapply the hot fix?
> Thanks in advance for any information.
> Emil
|||use culture;
SELECT * from FREETEXTTABLE(tblMasterEvents,*,'art');
Get this:
Search on full-text catalog 'culture' for database ID 41, table ID
1381579960 with search condition 'art' failed with unknown result (565f9c4).
The name of the database is not relevant, as all return the error.
Thanks for looking.
Emil Caruthers
"Hilary Cotter" wrote:

> what is the exact error message you are getting?
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Emil" <emilcaruthers@.hotmail.com> wrote in message
> news:698301c4758b$4e941cd0$a301280a@.phx.gbl...
>
>
|||Emil,
Since your customer has already applied SP4, I'm assuming that this is a SQL
Server 7.0 installation as there currently is no publicly released SP4 for
SQL Sever 2000.
For SQL Server 7.0 installations, there is a registry key and value that you
can change in order to successfully re-install SP4 after applying a post-SP4
hotfix. Specifically, registry key called
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQL Server\Current Version\
"CSDVersion"
It will contain your hotfix build version number such that 7.00.xxx is the
build number. Record this value and then change it to the SP4 build value of
7.00.1063 and then re-install SP4. If successful, then re-install your
hotfix and confirm that this registry key value has changed back to your
recorded hotfix build number.
BTW, the hex value in the unknown result below is a 'garbage' value as this
is a bug with SQL Server 7.0 FTS and is fixed by applying (or re-applying)
the latest service pack.
Regards,
John
"Emil" <Emil@.discussions.microsoft.com> wrote in message
news:76173F35-121A-4ED7-852F-3328824CEC69@.microsoft.com...
> use culture;
> SELECT * from FREETEXTTABLE(tblMasterEvents,*,'art');
> Get this:
> Search on full-text catalog 'culture' for database ID 41, table ID
> 1381579960 with search condition 'art' failed with unknown result
(565f9c4).[vbcol=seagreen]
>
> The name of the database is not relevant, as all return the error.
> Thanks for looking.
> --
> Emil Caruthers
>
> "Hilary Cotter" wrote:
|||Thank you kindly, and I will try this.
Emil
Emil Caruthers
"John Kane" wrote:

> Emil,
> Since your customer has already applied SP4, I'm assuming that this is a SQL
> Server 7.0 installation as there currently is no publicly released SP4 for
> SQL Sever 2000.
> For SQL Server 7.0 installations, there is a registry key and value that you
> can change in order to successfully re-install SP4 after applying a post-SP4
> hotfix. Specifically, registry key called
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQL Server\Current Version\
> "CSDVersion"
> It will contain your hotfix build version number such that 7.00.xxx is the
> build number. Record this value and then change it to the SP4 build value of
> 7.00.1063 and then re-install SP4. If successful, then re-install your
> hotfix and confirm that this registry key value has changed back to your
> recorded hotfix build number.
> BTW, the hex value in the unknown result below is a 'garbage' value as this
> is a bug with SQL Server 7.0 FTS and is fixed by applying (or re-applying)
> the latest service pack.
> Regards,
> John
>
> "Emil" <Emil@.discussions.microsoft.com> wrote in message
> news:76173F35-121A-4ED7-852F-3328824CEC69@.microsoft.com...
> (565f9c4).
>
>

Full text indexing is haging

I have installed full text searching on a table on Sql 2000 (sp4 is
installed).
It is hanging while it is indexing. I have the re-indexing set at
every 10 minutes.
Any ideas?
Thanks,
Marc
Is there a lot of activity on this table? Expect locking if the table is
heavily updated. Try to run profiler to give you hints as to what is
occurring on the table during the population. Also what sort of population
are you running? I think you will find that change tracking offers the best
performance.
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
"Marc" <Marc@.discussions.microsoft.com> wrote in message
news:E9D4E872-A2C3-4176-9210-A0BA654A126B@.microsoft.com...
> I have installed full text searching on a table on Sql 2000 (sp4 is
> installed).
> It is hanging while it is indexing. I have the re-indexing set at
> every 10 minutes.
> Any ideas?
> Thanks,
> Marc
>

Full Text - Cannot Delete

We just migrated our SQL Server 2000 (SP4) to a cluster, keeping the same
name etc. Everything is working fine with the exception of one database. The
issue is that this database full text index is pointing to 'D:\MSSQL
Catalogs' which does not exist anymore. Is there a way to remove the full
text index and recreate it? I get errors when I try to delete it. I get
error 20565 - database is not full-text enabled yet. I use the exec
sp_fulltext_database 'enable' command and receive -
(1 row(s) affected)
(0 row(s) affected)
Server: Msg 7627, Level 16, State 1, Procedure sp_fulltext_database, Line 61
Full-text catalog in directory 'D:\MSSQL Catalogs' for clustered server
cannot be created. Only directories on a disk in the cluster group of the
server can be used.
Thank you!
Backup your database. Kick all users off it. Then using EM right click on
the tables you are full-text indexing and delete the full-text indexes on
them. When you have completed this, try to create another catalog, delete it
through EM, and then delete the contents of sysfulltextcatalogs.
If this doesn't work try this in QA
sp_help_fulltext_catalogs
to get the names of your fulltext catalogs and then try
declare @.int int
declare @.string varchar(200)
Create table holding
(
TABLE_OWNER sysname,
TABLE_NAME sysname,
FULLTEXT_KEY_INDEX_NAME sysname,
FULLTEXT_KEY_COLID int,
FULLTEXT_INDEX_ACTIVE int,
FULLTEXT_CATALOG_NAME sysname)
insert into holding
exec sp_help_fulltext_tables 'test1234'
select @.int = @.@.rowcount
while @.int>0
begin
select @.string='sp_fulltext_table ''' +table_name+''',''drop''' from holding
exec (@.string)
delete from holding
select @.int=@.int-1
end
exec sp_fulltext_catalog 'CatalogName','drop'
GO
"Gabe Matteson\" <gmatteson.rounder.com.nospam> wrote in message
news:%23r71zSgfHHA.4596@.TK2MSFTNGP05.phx.gbl...
> We just migrated our SQL Server 2000 (SP4) to a cluster, keeping the same
> name etc. Everything is working fine with the exception of one database.
> The issue is that this database full text index is pointing to 'D:\MSSQL
> Catalogs' which does not exist anymore. Is there a way to remove the full
> text index and recreate it? I get errors when I try to delete it. I get
> error 20565 - database is not full-text enabled yet. I use the exec
> sp_fulltext_database 'enable' command and receive -
> (1 row(s) affected)
> (0 row(s) affected)
> Server: Msg 7627, Level 16, State 1, Procedure sp_fulltext_database, Line
> 61
> Full-text catalog in directory 'D:\MSSQL Catalogs' for clustered server
> cannot be created. Only directories on a disk in the cluster group of the
> server can be used.
> Thank you!
>

Full Text - Cannot Delete

We just migrated our SQL Server 2000 (SP4) to a cluster, keeping the same
name etc. Everything is working fine with the exception of one database. The
issue is that this database full text index is pointing to 'D:\MSSQL
Catalogs' which does not exist anymore. Is there a way to remove the full
text index and recreate it? I get errors when I try to delete it. I get
error 20565 - database is not full-text enabled yet. I use the exec
sp_fulltext_database 'enable' command and receive -
(1 row(s) affected)
(0 row(s) affected)
Server: Msg 7627, Level 16, State 1, Procedure sp_fulltext_database, Line 61
Full-text catalog in directory 'D:\MSSQL Catalogs' for clustered server
cannot be created. Only directories on a disk in the cluster group of the
server can be used.
Thank you!
Backup your database. Kick all users off it. Then using EM right click on
the tables you are full-text indexing and delete the full-text indexes on
them. When you have completed this, try to create another catalog, delete it
through EM, and then delete the contents of sysfulltextcatalogs.
If this doesn't work try this in QA
sp_help_fulltext_catalogs
to get the names of your fulltext catalogs and then try
declare @.int int
declare @.string varchar(200)
Create table holding
(
TABLE_OWNER sysname,
TABLE_NAME sysname,
FULLTEXT_KEY_INDEX_NAME sysname,
FULLTEXT_KEY_COLID int,
FULLTEXT_INDEX_ACTIVE int,
FULLTEXT_CATALOG_NAME sysname)
insert into holding
exec sp_help_fulltext_tables 'test1234'
select @.int = @.@.rowcount
while @.int>0
begin
select @.string='sp_fulltext_table ''' +table_name+''',''drop''' from holding
exec (@.string)
delete from holding
select @.int=@.int-1
end
exec sp_fulltext_catalog 'CatalogName','drop'
GO
"Gabe Matteson\" <gmatteson.rounder.com.nospam> wrote in message
news:%23r71zSgfHHA.4596@.TK2MSFTNGP05.phx.gbl...
> We just migrated our SQL Server 2000 (SP4) to a cluster, keeping the same
> name etc. Everything is working fine with the exception of one database.
> The issue is that this database full text index is pointing to 'D:\MSSQL
> Catalogs' which does not exist anymore. Is there a way to remove the full
> text index and recreate it? I get errors when I try to delete it. I get
> error 20565 - database is not full-text enabled yet. I use the exec
> sp_fulltext_database 'enable' command and receive -
> (1 row(s) affected)
> (0 row(s) affected)
> Server: Msg 7627, Level 16, State 1, Procedure sp_fulltext_database, Line
> 61
> Full-text catalog in directory 'D:\MSSQL Catalogs' for clustered server
> cannot be created. Only directories on a disk in the cluster group of the
> server can be used.
> Thank you!
>

Full Text - Cannot Delete

We just migrated our SQL Server 2000 (SP4) to a cluster, keeping the same
name etc. Everything is working fine with the exception of one database. The
issue is that this database full text index is pointing to 'D:\MSSQL
Catalogs' which does not exist anymore. Is there a way to remove the full
text index and recreate it? I get errors when I try to delete it. I get
error 20565 - database is not full-text enabled yet. I use the exec
sp_fulltext_database 'enable' command and receive -
(1 row(s) affected)
(0 row(s) affected)
Server: Msg 7627, Level 16, State 1, Procedure sp_fulltext_database, Line 61
Full-text catalog in directory 'D:\MSSQL Catalogs' for clustered server
cannot be created. Only directories on a disk in the cluster group of the
server can be used.
Thank you!Backup your database. Kick all users off it. Then using EM right click on
the tables you are full-text indexing and delete the full-text indexes on
them. When you have completed this, try to create another catalog, delete it
through EM, and then delete the contents of sysfulltextcatalogs.
If this doesn't work try this in QA
sp_help_fulltext_catalogs
to get the names of your fulltext catalogs and then try
declare @.int int
declare @.string varchar(200)
Create table holding
(
TABLE_OWNER sysname,
TABLE_NAME sysname,
FULLTEXT_KEY_INDEX_NAME sysname,
FULLTEXT_KEY_COLID int,
FULLTEXT_INDEX_ACTIVE int,
FULLTEXT_CATALOG_NAME sysname)
insert into holding
exec sp_help_fulltext_tables 'test1234'
select @.int = @.@.rowcount
while @.int>0
begin
select @.string='sp_fulltext_table ''' +table_name+''',''drop''' from holding
exec (@.string)
delete from holding
select @.int=@.int-1
end
exec sp_fulltext_catalog 'CatalogName','drop'
GO
"Gabe Matteson\" <gmatteson.rounder.com.nospam> wrote in message
news:%23r71zSgfHHA.4596@.TK2MSFTNGP05.phx.gbl...
> We just migrated our SQL Server 2000 (SP4) to a cluster, keeping the same
> name etc. Everything is working fine with the exception of one database.
> The issue is that this database full text index is pointing to 'D:\MSSQL
> Catalogs' which does not exist anymore. Is there a way to remove the full
> text index and recreate it? I get errors when I try to delete it. I get
> error 20565 - database is not full-text enabled yet. I use the exec
> sp_fulltext_database 'enable' command and receive -
> (1 row(s) affected)
> (0 row(s) affected)
> Server: Msg 7627, Level 16, State 1, Procedure sp_fulltext_database, Line
> 61
> Full-text catalog in directory 'D:\MSSQL Catalogs' for clustered server
> cannot be created. Only directories on a disk in the cluster group of the
> server can be used.
> Thank you!
>

Full Text - Cannot Delete

We just migrated our SQL Server 2000 (SP4) to a cluster, keeping the same
name etc. Everything is working fine with the exception of one database. The
issue is that this database full text index is pointing to 'D:\MSSQL
Catalogs' which does not exist anymore. Is there a way to remove the full
text index and recreate it? I get errors when I try to delete it. I get
error 20565 - database is not full-text enabled yet. I use the exec
sp_fulltext_database 'enable' command and receive -
(1 row(s) affected)
(0 row(s) affected)
Server: Msg 7627, Level 16, State 1, Procedure sp_fulltext_database, Line 61
Full-text catalog in directory 'D:\MSSQL Catalogs' for clustered server
cannot be created. Only directories on a disk in the cluster group of the
server can be used.
Thank you!Backup your database. Kick all users off it. Then using EM right click on
the tables you are full-text indexing and delete the full-text indexes on
them. When you have completed this, try to create another catalog, delete it
through EM, and then delete the contents of sysfulltextcatalogs.
If this doesn't work try this in QA
sp_help_fulltext_catalogs
to get the names of your fulltext catalogs and then try
declare @.int int
declare @.string varchar(200)
Create table holding
(
TABLE_OWNER sysname,
TABLE_NAME sysname,
FULLTEXT_KEY_INDEX_NAME sysname,
FULLTEXT_KEY_COLID int,
FULLTEXT_INDEX_ACTIVE int,
FULLTEXT_CATALOG_NAME sysname)
insert into holding
exec sp_help_fulltext_tables 'test1234'
select @.int = @.@.rowcount
while @.int>0
begin
select @.string='sp_fulltext_table ''' +table_name+''',''drop''' from holding
exec (@.string)
delete from holding
select @.int=@.int-1
end
exec sp_fulltext_catalog 'CatalogName','drop'
GO
"Gabe Matteson\" <gmatteson.rounder.com.nospam> wrote in message
news:%23r71zSgfHHA.4596@.TK2MSFTNGP05.phx.gbl...
> We just migrated our SQL Server 2000 (SP4) to a cluster, keeping the same
> name etc. Everything is working fine with the exception of one database.
> The issue is that this database full text index is pointing to 'D:\MSSQL
> Catalogs' which does not exist anymore. Is there a way to remove the full
> text index and recreate it? I get errors when I try to delete it. I get
> error 20565 - database is not full-text enabled yet. I use the exec
> sp_fulltext_database 'enable' command and receive -
> (1 row(s) affected)
> (0 row(s) affected)
> Server: Msg 7627, Level 16, State 1, Procedure sp_fulltext_database, Line
> 61
> Full-text catalog in directory 'D:\MSSQL Catalogs' for clustered server
> cannot be created. Only directories on a disk in the cluster group of the
> server can be used.
> Thank you!
>

FTS Installation Problem - unavailable in SQL Server

Hello, I have a SQL Server 2000 sp4 server. Trying to install Full-Text
Search. I can see the Microsoft Search service and it shows as started. But
the Full-Text Search option in SEM is 'grayed out'. The FTS system procs
also report that FTS is not available. SQL Server has been stopped/restarted
but still no luck. Is there something else that needs to happen to make SQL
Server 2K see that FTS is installed?
- Thanks,
Chris M.
Does this help?
http://www.indexserverfaq.com/tablenotenabled.htm
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
"Chris M" <ChrisM@.discussions.microsoft.com> wrote in message
news:C445089B-5F09-40D9-B376-C6F60B669E86@.microsoft.com...
> Hello, I have a SQL Server 2000 sp4 server. Trying to install Full-Text
> Search. I can see the Microsoft Search service and it shows as started.
> But
> the Full-Text Search option in SEM is 'grayed out'. The FTS system procs
> also report that FTS is not available. SQL Server has been
> stopped/restarted
> but still no luck. Is there something else that needs to happen to make
> SQL
> Server 2K see that FTS is installed?
> - Thanks,
> Chris M.