Home Forums SQL Server 2005 Administering Error 229: Execute permition denied on object............. RE: Error 229: Execute permition denied on object.............

  • I'm having the same permission problems. I use to put my agent operators in the sqlAgentOperatorRole in the msdb database. Thisa would allow them to go under the jobs and view and execute all jobs.

    Does anyone know if a SP2 roll up changed this? I did restore msdb from a backup but I do not think it would have changed the XP_ permissions.