Full text stuck in a rut - error msg 7619

I have a full-text index on a production db. The catalog is currently empty. When I try to populate it, I get a message saying I must enable full text for this database. When I try to run sp_fulltext_database 'enable', I get the following message:
Server: Msg 7619, Level 16, State 1, Procedure sp_fulltext_database, Line 61
Execution of a full-text operation failed. The process cannot access the file because it is being used by another process.
Our OS team could not find any processes other than sqlserver.exe using files in the FTData dir. MSSearch is currently owned by the localsystem account, and ownership has not been changed since the SQL Server install.
I am using SQL 2000 EE. on a Windows 2000 cluster. SP3A is installed.
Has anyone else come across this error? Any advice would be appreciated!

Quote:

Originally posted by lisanova22
I have a full-text index on a production db. The catalog is currently empty. When I try to populate it, I get a message saying I must enable full text for this database. When I try to run sp_fulltext_database 'enable', I get the following message:
Server: Msg 7619, Level 16, State 1, Procedure sp_fulltext_database, Line 61
Execution of a full-text operation failed. The process cannot access the file because it is being used by another process.
Our OS team could not find any processes other than sqlserver.exe using files in the FTData dir. MSSearch is currently owned by the localsystem account, and ownership has not been changed since the SQL Server install.
I am using SQL 2000 EE. on a Windows 2000 cluster. SP3A is installed.
Has anyone else come across this error? Any advice would be appreciated!

Full Text Search

I have a strange issue with full text search. I have a table that has only 700 records in it, when I enable full text search and follow the wizard the index is not getting build. the storage full text say it is populating and it never does. I have restarted the service and rebuild the index few times with no benefits. I can do the same steps on another server with the same database and it works just fine. does anyone have any hints or things I can try? Please help

Check what are privileges associated with the login used to create this fulltext, also check whether MSsearch service is up and running.

Did you get any errors or warnings during thsi process?

|||

MSFTESQL is up and running. I don't get any errors when creating the Index. everything is successful status but when I am looking the property of the full text under storage the status is always "populating Catalog". The only error I can see is in the event viewer-

Performance Counters could not be loaded for msftesqlFD for instance MSSQLSERVER due to the following error: The system cannot find the file specified. 0x80070002.

not sure if this is related to full text search?

Please help.

Full Text Search

Hi,
We have a windows 2003 server (standalone) running SQL server 2000. We need to enable full text search on the database available in it. We have already added full text search in the installation and the option is available but when we try to create a full text catalog on any of the databases, it crashes ie., doesnot respond and gives the typical 'report to microsoft window'. We need to restart the SQL server after the same. can someone help us out.
Thanks
SmithAnything show up in the SQL Server errorlog? Also, did you apply all the service packs so the full Text Search executables are at the same version as the rest of your SQL Server?|||thanks for the reply
no nothing is shown in the event viewer. yes the service packs are the same..
smith|||How about SQL Server's errorlog?|||no help in errorlog too..|||Hi
We had rebuild the SQL server and now we are able to do FTS on just a single database. When we try to create Full Text catalog on other databases the MSSearch service stops. When we restart it, mssql is stopped. Is it not possible to have FTS in more than one database??

Thanks
Smith|||In SQL Server 2005 you can have multiple catalog for one database but each catalog can not contain more than one database.sql

Full Text Search

I did not install full text search on my server. Now I
think I will need it. I tried to enable it and found out
that I couldn't because it was not installed. I have 2
questions. 1) Do I just need to put in the CD and do a re-
install in order to select the FTS component?
2) What is the impact of installing Full Text Search?
Anything negative, positive? Thanks.
John
1) install from SQL CD. just click on the box.
2) It has big impact on memory and cpu usage. repopulating the catalogs is a
resource consuming process. So you would need to prepare a powerful box for
the sql server install.
"John Bull" <anonymous@.discussions.microsoft.com> wrote in message
news:094f01c49736$bb252b60$a401280a@.phx.gbl...
> I did not install full text search on my server. Now I
> think I will need it. I tried to enable it and found out
> that I couldn't because it was not installed. I have 2
> questions. 1) Do I just need to put in the CD and do a re-
> install in order to select the FTS component?
> 2) What is the impact of installing Full Text Search?
> Anything negative, positive? Thanks.
> John
|||Thank you much.
John

>--Original Message--
>1) install from SQL CD. just click on the box.
>2) It has big impact on memory and cpu usage.
repopulating the catalogs is a
>resource consuming process. So you would need to prepare
a powerful box for
>the sql server install.
>
>"John Bull" <anonymous@.discussions.microsoft.com> wrote
in message[vbcol=seagreen]
>news:094f01c49736$bb252b60$a401280a@.phx.gbl...
out[vbcol=seagreen]
re-
>
>.
>
sql

Full Text Search

I did not install full text search on my server. Now I
think I will need it. I tried to enable it and found out
that I couldn't because it was not installed. I have 2
questions. 1) Do I just need to put in the CD and do a re-
install in order to select the FTS component?
2) What is the impact of installing Full Text Search?
Anything negative, positive? Thanks.
John1) install from SQL CD. just click on the box.
2) It has big impact on memory and cpu usage. repopulating the catalogs is a
resource consuming process. So you would need to prepare a powerful box for
the sql server install.
"John Bull" <anonymous@.discussions.microsoft.com> wrote in message
news:094f01c49736$bb252b60$a401280a@.phx.gbl...
> I did not install full text search on my server. Now I
> think I will need it. I tried to enable it and found out
> that I couldn't because it was not installed. I have 2
> questions. 1) Do I just need to put in the CD and do a re-
> install in order to select the FTS component?
> 2) What is the impact of installing Full Text Search?
> Anything negative, positive? Thanks.
> John|||Thank you much.
John
>--Original Message--
>1) install from SQL CD. just click on the box.
>2) It has big impact on memory and cpu usage.
repopulating the catalogs is a
>resource consuming process. So you would need to prepare
a powerful box for
>the sql server install.
>
>"John Bull" <anonymous@.discussions.microsoft.com> wrote
in message
>news:094f01c49736$bb252b60$a401280a@.phx.gbl...
>> I did not install full text search on my server. Now I
>> think I will need it. I tried to enable it and found
out
>> that I couldn't because it was not installed. I have 2
>> questions. 1) Do I just need to put in the CD and do a
re-
>> install in order to select the FTS component?
>> 2) What is the impact of installing Full Text Search?
>> Anything negative, positive? Thanks.
>> John
>
>.
>

full text indexing

is there a way to enable full text indexing on SQL Server 2005 Express?

i know that the advanced edition can do so, but i am wondering if there is a registry hack or something that i can use instead of reinstalling.

any ideas?

thanks

No. SQL Express 2005 is missing several full-text files and a service. There is no quick hack to get it to work. The best way is to save your databases and simply upgrade.|||yes, you needs the SQL Server 2005 Express Edition with Advanced Services from 12.04.2006, it contains the service for the full-text search.

Full Text Indexing

Is it possible, in a SQL Server 2000 environment, to enable Full Text Indexing without having the BUILTIN\administrators account (as it was deleted due to securitry concerns)?
Thanks in advance for any & all input.You can add [NT Authority]\System as an admin to the SQL Server instance you want to use Full-Text on, and that should work as well.

Thanks,
--andrew

Full text index functino not installed properly

I recently upgraded a SQL server 7 installation to 2000 sp3a. This morning I
need to enable full text indexing. I went through the installation process
but the indexing options are not showing up. I tried a CLI and it told me
the services are not installed. How can I troubleshoot full text
installation or re-installs the serviceS?
The Microsoft Search service can be installed via the SQL Server setup
program. You might try the Add/Remove Programs entry for SQL Server to see
if you can add just the MS Search service.
HTH
Jerry
"CPLEV" <CPLEV@.discussions.microsoft.com> wrote in message
news:89D35CE3-D649-4AF6-8A3E-EB9ABD71105B@.microsoft.com...
>I recently upgraded a SQL server 7 installation to 2000 sp3a. This morning
>I
> need to enable full text indexing. I went through the installation
> process
> but the indexing options are not showing up. I tried a CLI and it told me
> the services are not installed. How can I troubleshoot full text
> installation or re-installs the serviceS?

Full text index functino not installed properly

I recently upgraded a SQL server 7 installation to 2000 sp3a. This morning
I
need to enable full text indexing. I went through the installation process
but the indexing options are not showing up. I tried a CLI and it told me
the services are not installed. How can I troubleshoot full text
installation or re-installs the serviceS?The Microsoft Search service can be installed via the SQL Server setup
program. You might try the Add/Remove Programs entry for SQL Server to see
if you can add just the MS Search service.
HTH
Jerry
"CPLEV" <CPLEV@.discussions.microsoft.com> wrote in message
news:89D35CE3-D649-4AF6-8A3E-EB9ABD71105B@.microsoft.com...
>I recently upgraded a SQL server 7 installation to 2000 sp3a. This morning
>I
> need to enable full text indexing. I went through the installation
> process
> but the indexing options are not showing up. I tried a CLI and it told me
> the services are not installed. How can I troubleshoot full text
> installation or re-installs the serviceS?

Full text index functino not installed properly

I recently upgraded a SQL server 7 installation to 2000 sp3a. This morning I
need to enable full text indexing. I went through the installation process
but the indexing options are not showing up. I tried a CLI and it told me
the services are not installed. How can I troubleshoot full text
installation or re-installs the serviceS?The Microsoft Search service can be installed via the SQL Server setup
program. You might try the Add/Remove Programs entry for SQL Server to see
if you can add just the MS Search service.
HTH
Jerry
"CPLEV" <CPLEV@.discussions.microsoft.com> wrote in message
news:89D35CE3-D649-4AF6-8A3E-EB9ABD71105B@.microsoft.com...
>I recently upgraded a SQL server 7 installation to 2000 sp3a. This morning
>I
> need to enable full text indexing. I went through the installation
> process
> but the indexing options are not showing up. I tried a CLI and it told me
> the services are not installed. How can I troubleshoot full text
> installation or re-installs the serviceS?