how to delete reference to fulltext catalog
- From: mattmerc@xxxxxxxxxxxxx
- Date: 30 Jan 2006 13:01:38 -0800
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.
.
- Prev by Date: corrupt full text catalogs -- can't delete!
- Next by Date: Re: Ignored words error strangeness
- Previous by thread: corrupt full text catalogs -- can't delete!
- Index(es):
Relevant Pages
|
Loading