
Signature
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
Thanks for your help.
The error message I'm getting in the logs is:
SQL Server Scheduled Job 'hm_build_ft' (0xC0B499F8F5AD3047803EC1417DC293A7)
- Status: Failed - Invoked on: 2005-07-19 01:35:37 - Message: The job failed.
The Job was invoked by User CIHWEBSQL\Edward. The last step to run was step
1 (drop_rebuild).
These are the (abbreviated) results of sp_help 'item':
Name Owner Type Created_datetime
item dbo user talbe 2005-07-12 19:53
Column_name Type Computed Length Prec Scale Nullable
item_id decimal no 9 18 0 no
TrimTrailingBlanks FixedLenNullInSource Collation
n/a n/a NULL
Identity Seed Increment Not for Replication
item_id 1 1 0
RowGuidCol
No rowguidcol column defined
Data_located_on_filegroup
PRIMARY
index_name index_description
PK_item clusered, unique, primary key located on PRIMARY
index_keys
item_id
constraint_type contraint_name
PRIMARY KEY (clustered) PK_item
delete_action, update_action, status_enabled, status_for_replication = n/a
constraint_keys
item_id
I have tried to create SQL FTS on the pubs database but the problem is the
same:
USE pubs
EXEC sp_fulltext_database 'enable'
USE pubs
EXEC sp_fulltext_catalog 'ft_temp','create'
USE pubs
EXEC sp_fulltext_table 'authors',
'drop'
USE pubs
EXEC sp_fulltext_table 'authors', 'create', 'ft_temp', 'PK_authors'
It creates the catalog but I don't get any further. Any help would be
greatly appreciated.
Thanks again,
ed
> This should work - what is the error message you are getting?
>
[quoted text clipped - 36 lines]
> >
> > ed
Hilary Cotter - 19 Jul 2005 17:09 GMT
Connect to your SQL Server in EM, expand the Management folder, expand SQL
Server agent, expand jobs, right click on the job select properties and then
change the job owner to sa. Restart your job and see if this fixes the
problem.

Signature
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
> Thanks for your help.
>
[quoted text clipped - 102 lines]
> > >
> > > ed
edwaldo - 19 Jul 2005 17:51 GMT
Thanks Hilary.
I tried the following job running under sa:
USE pubs
EXEC sp_fulltext_database 'enable'
USE pubs
EXEC sp_fulltext_catalog 'ft_temp','create'
USE pubs
EXEC sp_fulltext_table 'authors',
'drop'
USE pubs
EXEC sp_fulltext_table 'authors', 'create', 'ft_temp', 'PK_authors'
Again, the catalog was created but it failed on the last line (I assume).
Is there anything else I might be missing?
Many thanks,
Ed
> Connect to your SQL Server in EM, expand the Management folder, expand SQL
> Server agent, expand jobs, right click on the job select properties and then
[quoted text clipped - 113 lines]
> > > >
> > > > ed