Can't define full-text index in Microsoft Sql Server 2008

[fiaolle]

Hi I have tried to define a full-text index, but when I come to the dialog define population schedules in the wizard, I get errors. :(( The errors are This wizard will close because it encountered the following error: (Microsoft SQL Server) Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) EXECUTE permission denied on object 'sp_help_category', database 'msdb', schema 'dbo'. SELECT permission denied on object 'sysjobs_view', database 'msdb', schema 'dbo'. (.Net SqlClient Data Provider) Error Number: 229 Severity: 14 State: 5 Procedure: sp_help_category Line Number: 1 I followed the article in Codeproject http://www.codeproject.com/KB/database/SQLServer2K8FullTextSearh.aspx Please Help Me Regards Fia

[The Man from U N C L E]

You will need to be in the dbo_role on the msdb database.

If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) [My Articles]  [My Website]

[fiaolle]

Hi Thanks för your answer. What do I have to do, to become in the dbo_role. And what is the msdb database, is that the master database. The database I'm using is in a remote server, so what can I than do to define full-text index or can't I. Fia