• this will disable the xp_cmdshell command.

    ===============================

    EXECUTE sp_configure 'xp_cmdshell', 0

    RECONFIGURE

    For configuring more option use

    EXECUTE sp_configure this will help to know which options you can configure.

    ( available in both SQL 2000 & 2005 )

    You can also use Surface area Config In 2005.