How to delete full text catalog in SQL server 2005

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?
run profiler and see which command it is hanging on. Then you might want to
run it through query analyzer.
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
"shao" <shellyshao@.gmail.com> wrote in message
news:1142468617.986356.208590@.i39g2000cwa.googlegr oups.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
> 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?
>
|||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.
"shao" <shellyshao@.gmail.com> escribi en el mensaje
news:1142468617.986356.208590@.i39g2000cwa.googlegr oups.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
> 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?
>