How to Enable / Disable the Full-Text Index created on a View / Table ?

 Posted by PandianS on 9/16/2010 | Category: Sql Server Interview questions | Views: 4224 | Points: 40
Answer:

To Enable the Full-Text search Index already created on a View/Table :
EXEC dbo.sp_fulltext_table @tabname=N'[dbo].Table or View Name', @action=N'activate'

To Disable the Full-Text search Index already created on a View/Table :
EXEC dbo.sp_fulltext_table @tabname=N'[dbo].Table or View Name', @action=N'deactivate'


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response