Detach and Attach Full-Text catalogs in Sql Server 2005 easily
Last year about this time, I was playing around with a web spider that I worked on. Still am, but its on the shelf right now while I work on real things. Anyway, one of my complaints about trying to do full-text search with Sql 2000 was that when I moved the database onto a new drive, I was still seeing utilization on my main drive. One of the cool features of Sql Server 2005 is that the database actually contains the contents of the full-text catalogs. The result is that I can attach and detach databases and catalogs and they move around together because the catalogs are included in the databases. This is sweet. Full-Text Indexing is becoming more and more a full fledged piece of the database.
Update (2005-01-13): I think I am wrong on this. I've been looking through the filesystem and I've seen some stuff that looks like a catalog. I'll post on this later.