T-SQL SPROC to Re-Create a Full Text Catalog

I cannot claim any ownership over this code. It's a colleague's, but it's so handy that I have to document it somewhere.

This will create an SPROC to re-create a full text catalog, which of course can then be tied to a Job.

CREATE PROCEDURE p_RecreateFT_Articles
 
AS 
 
ALTER TABLE [dbo].[Articles] WITH NOCHECK ADD 
 CONSTRAINT [PK_Articles] PRIMARY KEY  CLUSTERED 
 (
  [Article_ID]
 )  ON [PRIMARY]
 
IF EXISTS (SELECT * FROM dbo.sysfulltextcatalogs WHERE NAME = 'FT_Articles')
EXEC sp_fulltext_catalog 'FT_Articles', 'drop'

-- Create the catalog if it doesn't already exist.
IF NOT EXISTS (SELECT * FROM dbo.sysfulltextcatalogs WHERE NAME = 'FT_Articles')
EXEC sp_fulltext_catalog 'FT_Articles', 'create'

-- Add the full text index to the table 
EXEC sp_fulltext_table '[dbo].[Articles]', 'create', 'FT_Articles', 'PK_Articles'

-- Add the columns to the full text index 
EXEC sp_fulltext_column '[dbo].[Articles]', 'ArticleTitle', 'add' 
EXEC sp_fulltext_column '[dbo].[Articles]', 'ArticleBody', 'add'

-- Activate the index
EXEC sp_fulltext_table '[dbo].[Articles]', 'activate' 

-- Start population
EXEC sp_fulltext_catalog   'FT_Articles', 'start_full'

GO