enable/disable Extende Stored Procedure in MSSQL2005

Hi,

Anybody now how to this programmaticly ? in registry or TSQL statement ?

Have you looked at the Surface Area Configuration tools - the feature configuration controls? That section allows you to disable buckets of XPs that are used by a feature you don't use, but you cannot deactivate only individual XPs in a bucket.

Thanks

Laurentiu

|||

if you refer only at running xp_cmdshell , i quote from Books Online

" Introduced in SQL Server 2005, the xp_cmdshell option is a server configuration option that enables system administrators to control whether the xp_cmdshell extended stored procedure can be executed on a system. By default, the xp_cmdshell option is disabled on new installations and can be enabled by using the Surface Area Configuration tool or by running the sp_configure "

for others xp's i didn't find anything

Enable tcp/ip protocol via registry

Well, I need to enable the tcp/ip protocol via registry,
so I added the following value inside the registry
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsof t SQL
Server\GESTP\MSSQLServer\SuperSocketNetLib\Tcp]
"TcpHideFlag"=dword:00000000
"TcpDynamicPorts"="0"
"TcpPort"="1433"
But if I call the svrnetcn tool tcp/ip isn't listed as enable protocol.
Why?
Andrea Moro
I forgot to say ... I want to enable the tcp/ip protcol
for a named instance.
I suspect that sql tool do more thing that alter the
registry keys I specified.
Andrea
|||hi Andrea,
"Andrea Moro" <moroandreaet@.ettiscali.it> ha scritto nel messaggio
news:%23dg$jOX2EHA.2180@.TK2MSFTNGP10.phx.gbl
> Well, I need to enable the tcp/ip protocol via registry,
> so I added the following value inside the registry
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsof t SQL
> Server\GESTP\MSSQLServer\SuperSocketNetLib\Tcp]
> "TcpHideFlag"=dword:00000000
> "TcpDynamicPorts"="0"
> "TcpPort"="1433"
> But if I call the svrnetcn tool tcp/ip isn't listed as enable
> protocol.
> Why?
you have to check
HKLM\SOFTWARE\Microsoft\Microsoft SQL
Server\InstanceName\MSSQLServer\SuperSocketNetLib
\ProtocolList
key, that must include the "tcp" value
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply