|
Microsoft
SQL
Server
Full-Text
Indexing
Instructions
Change
Tracking
(MSSQL
Server
2000
Only)
The
following
is done
using
Microsoft
Enterprise
Manager
included
with
Microsoft
SQL
Server:
-
Right-click
the
docs
table
in
the
Enterprise
Search
database
-
Click
Change
Tracking
(to
enable
it)
under
the
Full-Text
Index
Table
sub-menu
-
Right-click
the
docs
table
again
-
Click
on
Update
Index
In
Background
(to
enable
it)
under
the
Full-Text
Index
Table
sub-menu
Schedule
The
following
is done
using
Microsoft
Enterprise
Manager
included
with
Microsoft
SQL
Server:
-
Right-click
the
docs
table
in
the
Enterprise
Search
database
-
Click
Schedules
within
the
Full-Text
Index
Table
sub-menu
-
Click
New
Table
Schedule
-
Give
it a
name
-
Select
Incremental
population
under
Job
type
-
Select
Recurring
under
Schedule
frequency
-
Click
the
Change
button
-
Select
Daily
under
Occurs
-
Select
the
time
you
want
the
schedule
to
run
at
Occurs
once
at
under
Daily
frequency
-
Click
the
OK
button
to
save
the
schedule
frequency
-
Click
the
OK
button
once
back
at
the
previous
screen
to
save
the
schedule
-
Finally,
click
the
OK
button
again
Within
Enterprise
Search
The
following
is done
within
Enterprise
Search:
-
Select
the
Database
drop-down
menu
-
Click
Start
Full
Population
under
the
Full-Text
Index
sub-menu
or
-
Click
Start
Incremental
Population
or
-
Enable
"Automatically
start
incremental
population"
in
the
Options
under
the
Indexing
tab.
This
will
instruct
the
spider
to
automatically
trigger
the
incremental
population
after
the
spider
has
finished
indexing.
This
option
is
set
per
collection.
Full
Population
will
index
all
documents.
Incremental
Population
will
only
index
documents
that
have
changed,
were
added,
or were
removed.
Please
note,
that for
incremental
population
to work,
you must
have a
timestamp
column
in your
docs
table.
If you
do not
have
one, you
can
either
create
it
giving
it the
name
ts
or by
downloading
the
updated
innerprise.sql
SQL
Script
to
re-create
the
Enterprise
Search
database
(your
existing
index
data
will be
lost if
you
chose
this
method).
|