Unable to create full-text catalog

Unable to create full-text catalog - please help!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

almurph@altavista.com - 03 Dec 2007 11:40 GMT

Folks,

Please help! I am unable to create a full-text catalogue. When I
run the following command:

sp_fulltext_catalog 'Cat_Desc', 'create', 'f:\VENUS_SQL_DAT\MSSQL
\FTData'

I get the following command:

Server: Msg 7619, Level 16, State 2, Procedure sp_fulltext_catalog,
Line 64
The specified object cannot be found. Specify the name of an existing
object.

    I donlt know why this is happening?

    I have checked the following:

1. Yes, the path is mapped correctly and the location exists - I have
verified it visually
2. I ran: EXEC sp_fulltext_database 'enable'
and got the following output:

(1 row(s) affected)

(0 row(s) affected)

(1 row(s) affected)

3. I think its got something to do with the user I am in as. Quest:
How do I determine this? Is it select @@user? I'm a bit confused.

    Anyone with any ideas/suggestions/code-diagnostics etc I would be
most appreciative.

Thank you,
Al.

Reply to this Message

Ian Boyd - 05 Dec 2007 20:13 GMT

> Please help! I am unable to create a full-text catalogue. When I
> run the following command:
[quoted text clipped - 8 lines]
> The specified object cannot be found. Specify the name of an existing
> object.

Out of curiosity, what happens if you run:

USE [MyDatabaseName]
GO
EXEC dbo.sp_fulltext_catalog @ftcat=N'MyDatabaseCatalog', @action=N'create'

That's the command i use - i've never tried to specify a path for the
catalog. What happens when you don't include that, and let it put the
catalog wherever it wants?

And i have only ever run the command when logged in as "sa". You can see
who you're logged in as using:
SELECT USER_NAME()

If it returns "dbo", then it means you're logged in as someone who's a
member of the 'sysadmin' server role.

Reply to this Message

almurph@altavista.com - 06 Dec 2007 11:31 GMT

> > Please help! I am unable to create a full-text catalogue. When I
> > run the following command:
[quoted text clipped - 25 lines]
> If it returns "dbo", then it means you're logged in as someone who's a
> member of the 'sysadmin' server role.

Hi Ian,

Thanks for the comments/suggestions. When I run the command:

USE [MyDatabaseName]
GO
EXEC dbo.sp_fulltext_catalog @ftcat=N'MyDatabaseCatalog',
@action=N'create'

I get the exact same error message:

Server: Msg 7619, Level 16, State 2, Procedure sp_fulltext_catalog,
Line 64
The specified object cannot be found. Specify the name of an existing
object.

Running: SELECT USER_NAME()

return dbo. Should I be logged in as sa? I see that the server is
runniong under SQL Server and Windows authentication butr this is the
way it should be I believe. How do I check the permissions of dbo?

Confused,
Al.

Reply to this Message