if (select DATABASEPROPERTY(DB_NAME(), N'IsFullTextEnabled')) <> 1
exec sp_fulltext_database N'enable'
GO
if not exists (select * from dbo.sysfulltextcatalogs where name = N'down91')
exec sp_fulltext_catalog N'down91', N'create'
GO
exec sp_fulltext_table N'[dbo].[T_SoftInfo]', N'create', N'down91', N'PK_T_SoftInfo'
GO
---说明PK_T_SoftInfo必须是唯一的、不可为空的、单列的索引
exec sp_fulltext_column N'[dbo].[T_SoftInfo]', N'SoftName', N'add', 2052
GO
exec sp_fulltext_table N'[dbo].[T_SoftInfo]', N'activate'
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO