SQL Server 2000 Full text index components

  • I have a SQL Server 2000 instance with about 50 databases. I need to migrate them to a SQL Server 2008 instance. The upgrade advisor told me that these components will be affected:

    Component: .asx

    Component: .css

    Component: .hta

    Component: .htt

    Component: .idq

    Component: .pps

    Component: .xsl

    I'm not sure if these components are even being used. If the upgrade advisor says it, is it just a general warning that might not apply? If it does apply, how do I make the migration seamless?

  • Looks like some of the components of SQL 2005 are already installed. Un-installing them may help.

    Ref: http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/3e11d3fe-e9ad-4b4e-bc79-b975f94dcc69

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • I can't find evidence that full text searching was ever used. This concerns me because I think I'm not aware of why these components are installed. Therefore I may find out the hard way why they were needed -- after I uninstall them.

    What is the preferred way of uninstalling the components? Modifying the registry?

  • The preferred way of uninstalling is through "Add/Remove Programs" under Control Panel.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply