I am using SQL Server 2000 sp3 on windows 2000.

With an existing database, whenever I use the command

sp_fulltext_database enable or disable

The statement hangs for a long time. I have waited upto 45 minutes without a response.

Does anyone know why this happens or how I can get this statement to complete in a reasonable time.

FYI, When I tried the sp_fulltext_database enable/disable on a new database the statement executed immediately without any problem.

Thanks for your responses.