Re: sp_fulltext_table with SQL Server Agent - permissions problem?

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




"Hilary Cotter" wrote:

> This should work - what is the error message you are getting?
>
> Also can you issue an sp_help 'item' and post the results back here?
>
> Could you also try to create a full text index on the authors table in the
> pubs database on db2 to see if SQL FTS works there?
> --
> 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
>
> "edwaldo" <edwaldo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:6AA24EB4-EE58-45EB-80E6-0B37BBF65336@xxxxxxxxxxxxxxxx
> > Hi,
> >
> > I have two databases on separate servers - db1 & db2.
> >
> > I use DTS to copy the tables from db1 to db2 overnight. Then I want to
> > recreate the fulltext catalog on one of the tables in db2 using a SQL
> > Server
> > Agent job to run sp_fulltext_table:
> >
> > USE hm2
> > EXEC sp_fulltext_database 'enable'
> >
> > USE hm2
> > EXEC sp_fulltext_catalog 'ft_item', 'drop'
> >
> > USE hm2
> > EXEC sp_fulltext_catalog 'ft_item', 'create'
> >
> > USE hm2
> > EXEC sp_fulltext_table 'item', 'create', 'ft_item', 'item_id'
> >
> > This is where is fails (I think).
> >
> > The table I'm fulltext indexing has a primary key column defined (NOT
> > NULL).
> > When the overnight copy runs, the table is created under dbo, and the sql
> > agent job is running as dbo. I have BUILTIN\Administrators setup with the
> > correct permissions.
> >
> > Is this likely to be a permissions problem?
> >
> > Many thanks,
> >
> > ed
> >
> >
>
>
>
.

Relevant Pages

  • Re: No value given for one or more required parameters
    ... No this is not pubs from SQL 2000. ... There is no required filelds. ... >> Operation must use an updateable query. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SQL connection problem
    ... EXEC sp_defaultdb 'John', 'pubs' ... Detach the database and delete the LOG file. ... > I have sql 2000. ...
    (microsoft.public.sqlserver.programming)
  • Re: need help
    ... for both my db and the pubs db which the code works ... I did change my sql to thi: ... dbo.Task.comments FROM dbo.Team INNER JOIN dbo.Task ON ... Is the SQL Server you are hitting a local ...
    (microsoft.public.dotnet.languages.csharp)
  • retrieving data from database
    ... can u send a example for retrieving data into a form using the sql. ... use the database as 'pubs' ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)