Full Text Commands in SQL Query?

My host does allow me to create full text catalogs. I use SQL Server Management Studio Express, so I'd have to do it "by hand" as opposed to point-clicking menus and going through wizards. Where do I go to find those commands? I've seen them before but I can't remember where to get them. They're the ones that begin with sp_.

I need the commands for:

Creating a full text catalog

Specifying which columns and tables to enable full text searching

Scheduling when to update the catalog (when to repopulate, etc.)

Clearing the catalog to start over again

Any other handy/necessary commands?

Any help will be appreciated. Thank you.

i sent you that info here:http://forums.asp.net/t/1127286.aspx

|||

i sent you that info here:http://forums.asp.net/t/1127286.aspx

|||

That's creating the catalog and enabling table/column for full-text. I got those.

What about for scheduling population?

|||

1. Activate your database for full-text search:
sp_fulltext_database 'enable'
(Warning! An already existing index will be reset to the default settings.)

2. Create the full text index: To continue, a so-called catalog must be created:
sp_fulltext_catalog 'Fulltextcatalog1','create'
('Fulltextcatalog1' is the name of the catalog for this example)

and a virtual index:
sp_fulltext_table 'Employee','create','Fulltextcatalog1','pkID_Field'
(pkID_Field is the name of the Primary Key of table Employee.)

3. Add the fields that you want to be indexed:
(The fields have to be either the type char, varchar, nchar, nvarchar or text.)
sp_fulltext_column 'Employee','lastname','add'
sp_fulltext_column 'Employee','firstname','add'

where 'lastname' and 'firstname' are the field names used in this example.

4. Next you have to activate the index:
sp_fulltext_table 'Employee','activate'

5. After that the index can be generated with the following command:
sp_fulltext_table 'Employee','start_full'

6. Now activate the 'Change Tracking'. Required for this, is a field with the data
type 'timestamp'. Through this, the newly created index will automatically be
updated, as soon as the data in the columns has been changed.

sp_fulltext_table Employee, 'Start_change_tracking'
sp_fulltext_table Employee, 'Start_background_updateindex'

Deleting Full-text Indexing on a table named fulltext1

1. First delete the index:
sp_fulltext_table 'Employee', 'drop'

2. And then the catalog:
sp_fulltext_catalog 'fulltextcatalog1','drop'