Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

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

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 stackoverflow.com Jan 31 '12 at 13:52

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

1 Answer 1

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

 
discard

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