error 229

[moein serpico]

hi guys when i was tring to restor my db i faced with this error "the execution permission was denied on the object sp_enum_sqlagent_subsystems,database msdb,schema dbo-error 229" please help, my job is in danger i use sql server 2008

[Luc Pattyn]

I don't know, however my friend[^] does. ;)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

[moein serpico]

didi you know you are so cute and funny? ha!ha

[Dalek Dave]

This may help.[^]

------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC League Table Link CCC Link[^]

[Phil J Pearson]

or this[^]

Phil

---

The opinions expressed in this post are not necessarily those of the author, especially if you find them impolite, inaccurate or inflammatory.

[Dave Kreskowiak]

And? That's the first thing you do with an error message if you don't understand it.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak

[Lost User]

moein.serpico wrote:

"the execution permission was denied on the object sp_enum_sqlagent_subsystems,database msdb,schema dbo-error 229"

MSDN[^] states:

By default, members of the sysadmin fixed server role can execute this stored procedure. Other users must be granted the SQLAgentOperatorRole fixed database role in the msdb database.

I are Troll :suss:

[Jason Vetter]

haha that is sweet man! I didnt know that website existed.

[Luc Pattyn]

It is not the only one[^]... :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.