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 '
GoExec sp_fulltext_table n '[dbo]. [T_softinfo]', n'pk_t_softinfo'GO --- Description PK_T_SOFTINFO must be unique, unmoiled, single column index 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 goset ANSI_NULLS OFF GO
