SQLTeam.com | Weblogs | Forums

Check status RPC_out and xp_cmdshell

sql2008r2

#1

Hello, I need to check the status of RPC_out and xp_cmdshell for several servers. I would like to have a t-sql script or system table that tells the status of these two.

So I found how to check xp_cmdshell at http://sqltidbits.com/scripts/check-if-xpcmdshell-enabled-across-multiple-servers.

Now I need to find a way to check RPC_out.

Thanks
DJJ


#2

Found it

SELECT name, is_rpc_out_enabled 
FROM sys.servers 
ORDER BY name

Thanks

[edit]refine query[/edit]