How to delete full text catalog in SQL server 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shao - 16 Mar 2006 01:23 GMT

I copied a database. Then I need to delete full text catalog and
re-create one with exact same name. But it doesn't let me drop it. The
machine just hangs there forever when I try to drop it. So I read
through the usenet and found a way to delete it from
sysfulltextcatalogs in sql 2000. But in sql 2005, it doesn't let me
apply ad hoc updates. So what can I do to delete this full text
catalog. I have also searched through all the sys.sp*, but don't see
one to delete sysfulltextcatalogs. Tried the one
sys.sp_full_text_catalog, but doesn't work.
Anyone knows a solution?

Reply to this Message

Hilary Cotter - 16 Mar 2006 14:53 GMT

run profiler and see which command it is hanging on. Then you might want to
run it through query analyzer.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

>I copied a database. Then I need to delete full text catalog and
> re-create one with exact same name. But it doesn't let me drop it. The
[quoted text clipped - 6 lines]
> sys.sp_full_text_catalog, but doesn't work.
> Anyone knows a solution?

Reply to this Message

Antonio Soto - 18 Mar 2006 11:48 GMT

Did you try to remove the FT at service and table level? You can use the
stored procedures:
sp_fulltext_table
sp_fulltext_service

Antonio Soto
Solid Quality Learning

Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

Reply to this Message