Full-Text Indexing 1

[DrSql]

One of my server the Full-Text Indexing is diabled all other servers the feature is enabled. Any idea how can I enable that.

Dr.Sql
Good Luck.

 

[mrdenny]

It probably wan't installed with the SQL Server was installed. Pop that CD in and run through the installer. You should be able to reinstall just the full text part.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[DrSql]

Thanks.. Is there any way I can verfiy that's installed.
I will try that and keep you posted.

Dr.Sql
Good Luck.

 

[DrSql]

Thanks..It was installed on that server but the service was stopped. I was able start that. Now the question is there any way I can find which tables are Full-Text indexed is enabled in a DB.

Dr.Sql
Good Luck.

 

[mrdenny]

In EM Server > Databases > {Database} > Full-Text Catalogs

The basic full text info is in sysfulltextcatalogs.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[DrSql]

select * from sysfulltextcatalogs stores only the locatin of the folder where Catalogs are kept. Also need to generate catalogs for all tables inuvidually.
Thanks

Dr.Sql
Good Luck.

 

[cyno]

Run the following command in the QA

sp_help_fulltext_catalogs

It will return the catalog name. After that you can run this command specifying the catalog name as parameter to get table name


sp_help_fulltext_tables 'catalog name'

Cyno