How to turn on or off full text indexing in MS SQL server with sp_fulltext_database

Here is the snytax for it.

sp_fulltext_database [@action=] ‘action’

action is an argument and it’s type of varchar(20) and it could be enable or disable

To turn on full text indexing in MS SQL server with sp_fulltext_database try this.

USE Database_name;

GO
EXEC sp_fulltext_database 'enable';
GO

To turn off  full text indexing in MS SQL server with sp_fulltext_database try this:

USE Database_name;
GO
EXEC sp_fulltext_database 'disable';
GO

To run sp_fulltext_database you have to be db_owner or sysadmin