Hi, i'm trying to use sp_makewebtask, but it gives the error:
Quote:Msg 15281, Level 16, State 1, Procedure xp_makewebtask, Line 1
SQL Server blocked access to procedure 'sys.xp_makewebtask' of component 'Web Assistant Procedures' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Web Assistant Procedures' by using sp_configure. For more information about enabling 'Web Assistant Procedures', see "Surface Area Configuration" in SQL Server Books Online.
How do i enable it?
I've used:
EXECUTE sp_configure 'show advanced options', 1;
RECONFIGURE WITH OVERRIDE;
EXECUTE sp_configure 'xp_cmdshell', '1';
RECONFIGURE WITH OVERRIDE;
EXECUTE sp_configure 'show advanced options', 0;
RECONFIGURE WITH OVERRIDE
to enable xp_cmdshell.
could i use something similar for sp_makewebtask?
thx