Is there any way to enable Full Text Search on installed sql2008,without uninstalling it again
views:
223answers:
3Is there any way to enable Full Text Search on installed sql2008,without uninstalling it again
Full-text search is on by default but it is possible to toggle it on specific tables. Here is a tutorial on how to enable and disable full-text search in SQL Server 2008.
If you didn't install it as an optional component at the time of install, then running the installer again should detect the existing SQL Server instance. You can then pick it as an additional option to install and it will only install that component.
You should be able to re-run the installer from add/remove programs or the SQL Server DVD.
If you believe you installed it but it isn't working, you may find that your "SQL Server Full-text Daemon Launcher" service is disabled. Go to Control Panel -> Administrative Tools -> Services. Find the "SQL Server Full-text Daemon Launcher" entry, right click and select properties then enable it and start the service.