Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to run the following script on SQL 2000:

sp_configure 'show advanced options', 1;
sp_configure 'ave enabled' 1;
sp_configure 'Agent XPs', 1;

and get an Error:

"the configuration option 'agent XPs' does not exist or it may be an advanced option"

Any Idea?

share|improve this question

migrated from Jan 31 '12 at 13:52

This question came from our site for professional and enthusiast programmers.

up vote 3 down vote accepted

Agent XPs server option only exists on SQL Server 2005+ to enable legacy mail features.

For SQL Server 2000, it doesn't exist because you have to use Agent XPs for mail. There is no SMTP support via Database Mail

I really would considering upgrading, given SQL Server 2012 is due in a few weeks. There is no direct upgrade path from '2000 to '2012.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.