Tuesday, April 23, 2013

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 

No comments:

Post a Comment