[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 383
  • 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

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