SQL 2000 Full Text Index

[denacho]

How can I tell, after I've installed SQL 2000 on a Win2K3 server, if I installed Full Text Index? I know I picked Custom, but don't remember if I installed FTI. Is there a query or something that I can easily check that would tell me this?

 

[JayKusch]

Here ya go ...

By default, full-text search (Microsoft Search service) is installed when a Typical or Minimum installation of SQL Server 2000 Standard, Enterprise, or Developer Edition
is performed. During setup, SQL Server adds itself as an administrator of the Microsoft Search service.

In Microsoft SQL Server 7.0, you must perform a custom installation to install full-text search or you can add it after the installation as an Add-on component.
If you upgrade from SQL Server 7.0 to SQL Server 2000, only the components that were installed for SQL Server 7.0 are upgraded. If full-text search is not installed on SQL Server 7.0, the upgrade to SQL Server 2000 does not include full-text search. You must add it separately after the upgrade completes.

You have to consider the following limitations about the Microsoft Search service:

The Microsoft Search service is not available on:

Microsoft Windows NT Workstation
Microsoft Windows 2000 Professional
Microsoft Windows Millennium Edition
Microsoft Windows 98

SQL Server databases that run on these platforms do not support full-text catalogs and indexes. However, applications that run on these operating systems can use
full-text capabilities if they connect to an instance of SQL Server 2000 or SQL Server 7.0 on a different computer that supports them.

There is only one Microsoft Search service on any computer that runs multiple instances of SQL Server. A single instance of the full-text search engine manages the full-text indexes for all the instances of SQL Server 2000 and SQL Server 7.0 on the computer. FULL-TEXT SEARCH CHECKLIST

Thanks

J. Kusch

 

[denacho]

Thanks J.

When I installed SQL 2000, I chose Custom and I don't believe that I unselected Full-Text Search, but I wanted to make sure.