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: 4989 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

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