Re: Determining if Full-Text Search is enabled
- From: "Russell Fields" <russellfields@xxxxxxxxxx>
- Date: Tue, 27 Oct 2009 13:09:52 -0400
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@xxxxxxxxxxxxxxxxHello,
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?