How to turn on or off full text indexing in MS SQL server with sp_fulltext_database
21.10.2014
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