• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • Last Modified:

SQL 2005 help! How do I enable "Extended stored procedure"?

On SQL server 2005, I want to enable "Extended stored procedure" for agent.
How do I do that?
0
kinderwagen
Asked:
kinderwagen
  • 4
  • 3
1 Solution
 
patriktCommented:
I don't understant what you are after.
Rights for XP executiong are handled by GRANT, DENY, REVOKE commands.
Some system procedures are fixed to sysadmin role or need special configurations.
Which procedure is your problem?
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Add the xp like this
http://msdn2.microsoft.com/en-us/library/ms164653.aspx

Once you have successfully added the Xp, just cal that xp inside the job
0
 
kinderwagenAuthor Commented:
I mis-spelled.
I need "Agent Extended stored procedures" to be enabled. (so called Agent XPs?)
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
patriktCommented:
Ok, there is answer:

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO
0
 
kinderwagenAuthor Commented:
Thanks patrikt. That works!
0
 
patriktCommented:
And why you grade this C?
If you are giving C, please describe what was wron¨g on answer. It is not because of me, but because of others who will find thios PAQ.
0
 
kinderwagenAuthor Commented:
Because I'm new to this community, I mistakenly graded it.
I should have graded it A.
I searched the help but I've found there is no way to change the grade after accepting the answer.
0
 
patriktCommented:
It is not needed to change grade for me. I'm not points hunter. :)
I only wanted to know if something was not working.

If in future you will need help (bad grade, bad answer marked atc.) you should post to Community Support zone.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now