I have just installed SQL Server 2005 Developer Edition and attached the Pubs database that is enabled for full-text searching and I have run full-text searches on it using Sql Server 2005 Express. When i tried to search, I was informed that the catalog was not in a stable condition. I ran this script
Drop FullText Catalog PubsCatalog
I got this message:
Warning: The fulltext catalog 'PubsCatalog' is being dropped and is currently set as default.
When I try to create a new PubsCatalog, I get:
Msg 7689, Level 16, State 1, Line 1
Execution of a full-text operation failed. 'The dependency service does not exist or has been marked for deletion.'
I have tried other catalog names but the same result.
This was easy to do with the same db in Sql Server 2005 Express. What is wrong and how do I fix it?
The problem seems to be related to Vista. Sql Server 2005 SP2 fixed it.
No comments:
Post a Comment