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; (25062.01, « »)
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
http://sqlserver.itags.org/q_sql-server_351013.html
All Comments
Leave a comment...
- 0 Comments