"Linda" <lindap@empiredirect.co.uk> wrote in message
news:8854f45.0405050621.79951bfc@posting.google.com...
> When I try to execute the following stored procedure:
> exec sp_fulltext_database 'enable'
>
> I get the following error:
>
> Server: Msg 7619, Level 16, State 1, Procedure sp_fulltext_database,
> Line 46
> [Microsoft][ODBC SQL Server Driver][SQL Server]Execution of a
> full-text operation failed. The parameter is incorrect.
>
> I have change the account to use the system account but I still get
> this error.
>
> Can anyone help me please??

<anonymous@discussions.microsoft.com> wrote in message
news:932101c43355$383ff990$a301280a@phx.gbl...
> Hi John,
>
> Thanks for your reply.
>
> I ran the following:
> SELECT @@version
> SELECT @@language
>
> Which returned the following results:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195:
> Service Pack 4)
> British
>
> When I changed the account to the System account, I used
> SQL Server's Enterprise Manager's server property security
> tab.
> The full text search has been working fine for months but
> when the server was rebooted I could not enable the full
> text search.
>
> Thanks,
>
> Linda
>

<anonymous@discussions.microsoft.com> wrote in message
news:9a7e01c4340b$fd8c9530$a601280a@phx.gbl...
> Hi John,
>
> Below is the output that I get from running the following:
> use empiremaster
> go
> sp_configure 'default full-text language'
> go
> exec sp_help_fulltext_columns
>
> default full-text language 0
> 2147483647 1033 1033
>
> Server: Msg 15601, Level 16, State 1, Procedure
> sp_help_fulltext_columns, Line 8
> [Microsoft][ODBC SQL Server Driver][SQL Server]Full-Text
> Search is not enabled for the current database. Use
> sp_fulltext_database to enable Full-Text Search.
>
> Thanks again,
>
> Linda

<anonymous@discussions.microsoft.com> wrote in message
news:ab3801c4367b$8adf16d0$a501280a@phx.gbl...
>
> Hi John,
>
> I have ran your piece of code:
> use master
> go
> sp_configure 'default full-text language', 2057
> go
> reconfigure with override
> go
> and it has changed the language but I can not drop or
> recreate the catalogues because I get the error message
> saying that the database is not full-text enabled yet.
> But when I run:
> use empiremaster
> go
> exec sp_fulltext_database 'enable'
>
> I get the following message:
>
> Server: Msg 7619, Level 16, State 1, Procedure
> sp_fulltext_database, Line 46
> [Microsoft][ODBC SQL Server Driver][SQL Server]Execution
> of a full-text operation failed. The parameter is
> incorrect.
>
> Below is the result I get from running:
> use empiremaster
> go
> sp_configure 'default full-text language'
> go
> exec sp_help_fulltext_columns
>
> default full-text language 0
> 2147483647 2057 2057
>
> Server: Msg 15601, Level 16, State 1, Procedure
> sp_help_fulltext_columns, Line 8
> [Microsoft][ODBC SQL Server Driver][SQL Server]Full-Text
> Search is not enabled for the current database. Use
> sp_fulltext_database to enable Full-Text Search.
>
> Many thanks,
>
> Linda