Thanks for your reply, and yes, that would verify this one, but I have many Db backups and from time to time there will be a failure. What I would...

Thanks, missed that detail

That took care of it.

Many Thanks!

rw

Thanks, that answers the question!

rw

What do you mean "ask it to"? If I have criteria based on a field in the full text index, SQl will not use the full text index by default?

A transformation task from SQL statement to a table with batch size set at 2000 and always commit set true. All other settings are default.

Thanks again...it was an entry in the sys table

rw

Thanks, that makes sence and works great! But why is the catalog sill showing in Enterprise Manager under Full-Text Catalogs?

Thanks

rw