MS SQL Server - turn on agent xps

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

turn on agent xps

Newsreader

2006-12-07, 5:17 am

Hi,

I would like to get some help turning on Agents XPs

I found a code for doing that, but I can't figure out where to insert or
type it as I am just trying to solve a problem.
The SQL version is the newest 2005 Express.

This is the code I got:

>use master
>go
>sp_configure 'show advanced options', 1;
>GO
>RECONFIGURE;
>GO
>sp_configure 'Agent XPs', 1;
>go
>RECONFIGURE
>GO

Any help with detailed steps would be preciated

Sponsored Links