Re: Determining if Full-Text Search is enabled

Sorry, a clarification is that new databases will by default be enabled for full text indexing, but you do need to ensure that the full text indexing service was installed. If not, then rerun setup to add the full text service. (Reflecting an answer to your question in the fulltext newsgroup.)


"Russell Fields" <russellfields@xxxxxxxxxx> wrote in message news:eXt57UwVKHA.1268@xxxxxxxxxxxxxxxxxxxxxxx

In SQL Server 2005, Full Text indexing is installed as a matter of course (except for Express), but particularly if you have migrated in databases from SQL Server 2000, they may not be enabled to use it.

Yes, you can enable one database at a time. Here is a discussion


"tnt" <tnt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:5E53FED4-54B4-41FE-B5E1-DB204172CBAE@xxxxxxxxxxxxxxxx

How do I determine if this feature is enabled on a MS SQL 2005 Enterprise.
If it not enabled, can I enable it without affecting my current database?