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....
Hi, I'm getting the same error message. I'm using SQL Server 2008 Management Studio. How do I resolve this? Thanks
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.
I kinda solved the problem with instructions from the following link: http://support.discountasp.net/KB/a193/how-to-create-full-text-indexing-on-sql-2005-using.aspx Prior to this, I tried creating a full-text index by right clicking on a table and select Full-Text Index > Define Full-Text Index. I then follow the on-screen instructions. I get the error mentioned in my previous post. Not sure why it works one way, but not the other.