sp_fulltext_table with SQL Server Agent - permissions problem?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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


.