how to delete reference to fulltext catalog



Looks like I made a mistake I hope someone can help me with. I backed
up a SQL database that implements fulltext catalogs. I thought these
would be included in the backup...I was wrong. Not a problem to
recreate the catalogs except that the database still shows the
references to the old ones. It gives me an error if I try to delete. I
get an error if I try to rebuild. I have also tried command line with
no luck:

use dev_i3
EXEC sp_fulltext_catalog 'fcAttachment', 'drop'

I appear to be stuck because I have catalog references to catalogs that
do not exist on the new server. There must be a way to manually remove
this reference and start over...I hope!

Thanks in advance.

.



Relevant Pages


Loading