Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Removing full text catalogs
Message
 
 
To
27/04/2008 12:01:14
General information
Forum:
Microsoft SQL Server
Category:
Full text indexing
Miscellaneous
Thread ID:
01313368
Message ID:
01313378
Views:
9
This message has been marked as the solution to the initial question of the thread.
>I have three full text catalogs defined in Storage\Full Text Catalogs. When I do my import, it takes care of creating that. However, at the beginning of the import, I need to clean that out. What approach can I use to remove everything under that without even knowing the name of the catalogs and no matter if there is one or many?

Not tested suggestion. You can use sys.fulltext_indexes catalog view to get the list of indexes and drop them. After that you can drop catalogs using list from sys.fulltext_catalogs
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform