Sql Server Full Text Index Error

Discussion in 'Databases' started by Ekrem, Nov 30, 2009.

  1. Hi,
    When I try to create a full tex index i get this message:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    The EXECUTE permission was denied on the object 'sp_help_category', database 'msdb', schema 'dbo'.
    The SELECT permission was denied on the object 'sysjobs_view', database 'msdb', schema 'dbo'. (Microsoft SQL Server, Error: 229)

    Isn't full text index enabled on Winhost? Or does anyone get this message?
    thanks....
     
    Last edited by a moderator: Oct 14, 2015
  2. Ray

    Ray

    Where are you seeing this error? Are you using SQL Server 2008 Management Studio?
     
  3. Hi,
    I'm getting the same error message. I'm using SQL Server 2008 Management Studio. How do I resolve this?

    Thanks
     
  4. Ray

    Ray

    Are you trying to schedule a job on the SQL server?
     
  5. No. I created a new table in the database. I get the error when I try to enable Full-Text Indexing on the new table.
     
  6. Ray

    Ray

    Can you give us teh database name?
     
  7. Db name is DB_779_dexsea. Table name is dxw.

    Thanks
     
  8. Ray

    Ray

    Ok thanks for the follow up.
     

Share This Page