Tags: agent, agents, code, database, figure, insert, microsoft, mysql, oracle, server, sql, turn, turning, type, xps

turn on agent xps

On Database » Microsoft SQL Server

562 words with 0 Comments; publish: Sun, 01 Jun 2008 23:55:00 GMT; (250109.38, « »)

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

All Comments

Leave a comment...

  • 0 Comments