Re: Find out which table columns are included

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi,
This is my code:

Use Pubs
EXEC sp_fulltext_catalog 'Cat_Employee', 'create'

EXEC sp_fulltext_table 'employee', 'create', 'Cat_Employee', 'pk_emp_id'

EXEC sp_fulltext_column 'employee','fname','add', 0
EXEC sp_fulltext_column 'employee','lname','add', 0
EXEC sp_fulltext_column 'employee','pub_id','add', 0

EXEC sp_fulltext_table 'employee','activate'

EXEC sp_fulltext_catalog 'Cat_Employee', 'start_full'

EXEC sp_fulltext_table 'employee','start_change_tracking'
EXEC sp_fulltext_table 'employee','start_background_updateindex'


I go to EM and status of the catalog is Idle
and the Item count is 0 on the Status tab.


"Jack" <cawoodm@xxxxxxxxx> wrote in message
news:1147705632.982544.149410@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Alan

I usually enable fulltext indexing on a table with the following
template:

USE MyDatabase
EXEC sp_fulltext_database 'enable'
EXEC sp_fulltext_catalog 'MyTable_Fulltext', 'create'
EXEC sp_help_fulltext_catalogs 'MyTable_Fulltext'
EXEC sp_fulltext_table 'MyTable', 'create', 'MyTable_Fulltext',
'MyTable_PK'
EXEC sp_fulltext_column 'MyTable', 'MyBinaryColumn', 'add', 0,
'MyFilenameColumn'
EXEC sp_fulltext_column 'MyTable', 'MyTextColumn1', 'add', 0
EXEC sp_fulltext_column 'MyTable', 'MyTextColumn2', 'add', 0
EXEC sp_fulltext_column 'MyTable', 'MyTextColumn3', 'add', 0

(note: google will wrap lines 5 & 6)

Using this, it's up to you to specify which columns are indexed.

Jack



.

Relevant Pages

  • Re: System sproc to channel to database(s)
    ... permissions in master. ... use northwind ... use pubs ... exec dbo.sp_MS_marksystemobject 'dbo.sp_insertSomething' ...
    (microsoft.public.sqlserver.programming)
  • Re: sp_fulltext_table with SQL Server Agent - permissions problem?
    ... USE pubs ... EXEC sp_fulltext_catalog 'ft_temp','create' ... > Connect to your SQL Server in EM, expand the Management folder, expand SQL ... >>> Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.fulltext)
  • RE: Stored Pocs
    ... Ein möglicher Weg alles in einer einzigen S_Proc unterzubringen wäre ... USE PUBS ... EXEC test_me 2,2 ...
    (microsoft.public.de.sqlserver)
  • Re: bhatt
    ... constraint/constraint name defined on the table. ... use pubs ... EXEC sp_helpconstraint authors ... Vishal Parkar ...
    (microsoft.public.sqlserver.programming)
  • Re: Utilizing Return values from Stored Procedure
    ... Specify that the procedure parameter is an OUTPUT paarmeter. ... exec spLocal_HomeGetNextID @Column OUPUT, @MHRID ... "Keith" wrote in message ... > I'm executing a stored procedure from within a stored> procedure. ...
    (microsoft.public.sqlserver.server)