sql server full text search:
Hello,
I have an SQL Server (7 SP2) running several databases with full text
indexed tables. One of the full text catalogs seems to have been lost
and I can't rebuild it.
I tried using QA and entering ...
EXEC sp_fulltext_database 'enable'
exec sp_fulltext_catalog N'Products_FullTextIndex', N'create'
exec sp_fulltext_table N'[dbo].[products]', N'create',
N'Products_FullTextIndex', N'PK_products'
exec sp_fulltext_column N'[dbo].[products]', N'pname', N'add'
exec sp_fulltext_column N'[dbo].[products]', N'description', N'add'
exec sp_fulltext_table N'[dbo].[products]', N'activate'
EXEC sp_fulltext_catalog 'Products_FullTextIndex', 'start_full'
but I got the following error ...
Server: Msg 7605, Level 17, State 2, Procedure sp_fulltext_database,
Line 63
Full-text catalog '' has been lost. Use sp_fulltext_catalog to rebuild
and to repopulate this full-text catalog.
Whatever I do, I get this error. I have tried running just the first
two lines, but the same thing happens. If I run only the first line,
it gives the same error, if I run just the second line, it gives ...
Server: Msg 15601, Level 16, State 1, Line 1
Fulltext Search is not enabled for the current database. Use
sp_fulltext_database to enable full-text search.
Seems I am stuck here. Whatever I do, I get an error.
I tried creating the catalog using EM, but got the first error message
as soon as I tried to create it. I can't see what to do. It tells me
to run sp_fulltext_catalog, but when I do it tells me I can't run it
!!
Any help very much appreciated. As I said, several other databases on
the server have free text catalogues and are working fine.
If possible, please send a copy of any replies to me as my news server
doesn't carry this group, so I am having to access it via Google,
which is a pain. I don't always notice replies this way.
