Moving SQL 2000 to 2005 and Full Text Search problems

We have been slowly migrating databases from SQL 2000 to 2005, and as we do so we find that the Full Text Catalog isn’t brought over into 2005. This causes lots of issues, one being backup stops working. So how do you get rid of them? To find out what tables are indexed in the […]

We have been slowly migrating databases from SQL 2000 to 2005, and as we do so we find that the Full Text Catalog isn’t brought over into 2005. This causes lots of issues, one being backup stops working. So how do you get rid of them?

To find out what tables are indexed in the database you need to do some leg work. you need to find out what tables are indexed in the database, so by looking up the catalogs in the sysobject tables, we can get a list:

now run down the list of tables and run the following:

This clears out the entry for full text searching on the tables. This leaves the catalogue clear for deletion. So lets clear the full text index catalog, and clean things up just to be tidy.

Duncan Isaksen-Loxton

Educated as a web developer, with over 20 years of internet based work and experience, Duncan is a Google Workspace Certified Collaboration Engineer and a WordPress expert.
Login
Log in below to access your courses.
Log In With Google
Forgot Password
Enter your email address or username and we’ll send you instructions to reset your password.