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 

1 comment:

  1. Fun88 | Review & Bonus Code for UK Casinos 2021
    Fun88 casino review for fun88 vin 2021. Get our complete review of the new game selection, customer support, banking methods and the latest bonuses. 샌즈카지노 Rating: 5 · ‎Review sbobet ทางเข้า by Yetcasino

    ReplyDelete