I have a database that is hosted on SQL 2000. This database also has subscribers that will need to have the full text indexes scripted and applied. When I scripted the full text indexes on SQL 2000, the first problem was that the script didn't include the Full Text Catalog.
Can someone give me the rough steps to follow to migrate Full Text from SQL 2000 to SQL 2008? Seems like I am really close to completing this task, but I get errors stating that Full Text is not enabled when I try to run the FT index creation scripts.