Setup SQL Server Full-Text Index

pellerex-setup-full-text-index-using-sql-server.sql

IF  EXISTS (SELECT * FROM sys.fulltext_indexes fti WHERE fti.object_id = OBJECT_ID(N'[dbo].[Addresses]'))
ALTER FULLTEXT INDEX ON [dbo].[Addresses] DISABLE

GO
IF  EXISTS (SELECT * FROM sys.fulltext_indexes fti WHERE fti.object_id = OBJECT_ID(N'[dbo].[Addresses]'))
BEGIN
	DROP FULLTEXT INDEX ON [dbo].[Addresses]
End

Go
IF EXISTS (SELECT * FROM sys.fulltext_catalogs WHERE [name]='FTCAddress')
BEGIN
	DROP FULLTEXT CATALOG FTCAddress 
END

CREATE FULLTEXT CATALOG FTCAddress AS DEFAULT;
CREATE FULLTEXT INDEX ON dbo.Addresses(FullAddress) KEY INDEX PK_Addresses ON FTCAddress WITH STOPLIST = OFF, CHANGE_TRACKING AUTO;