Hello,

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?

TIA,
tnt

tnt,

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
http://www.kodyaz.com/articles/SQL-S...-Indexing.aspx

RLF

"tnt" <tnt (AT) discussions (DOT) microsoft.com> wrote

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.)

RLF

"Russell Fields" <russellfields (AT) nomail (DOT) com> wrote