Re: corrupt full text catalogs -- can't delete!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I was able to fix my problem this way:

Change path of freetext catalogs to a valid path (previously to a drive
that didnt exist)
repopulate
then delete

I used this script I found

use master
go
sp_configure allow,1
go
reconfigure with override
go
use dev_3
go
update sysfulltextcatalogs set path = 'e:\program files\microsoft sql
server\mssql\ftdata'
go
select * from sysfulltextcatalogs
go
use master
go
sp_configure allow,0
go
reconfigure with override
go

Thanks for the help

.

Relevant Pages

  • Re: Default Data/Log File Directory
    ... USE master ... EXEC sp_configure 'show advanced option', ... RECONFIGURE WITH OVERRIDE ...
    (microsoft.public.sqlserver.dts)
  • Re: recursion problem
    ... >> use master ... >> reconfigure with override ... >> start dt of parent task ...
    (microsoft.public.sqlserver.programming)
  • Re: sqlservr.exe memory problem
    ... To view the memory on your server, copy the following commands to a text ... USE master ... RECONFIGURE WITH OVERRIDE ...
    (microsoft.public.isaserver)
  • Re: Restoring from MDF and LDF
    ... reconfigure with override ... where name = 'BADDBNAME' ... Start database in emergency mode ...
    (microsoft.public.sqlserver.server)
  • Re: cannot ad hoc on system tables on SQL server 2005
    ... EXEC SP_configure 'allow updates',1 ... RECONFIGURE WITH OVERRIDE ... You should query the new catalog views and the DMVs instead. ...
    (microsoft.public.sqlserver.programming)