SQL Server Performance

config protocol

Discussion in 'SQL Server 2005 General Developer Questions' started by arkiboys, Jul 1, 2008.

  1. arkiboys Member

    Hi,
    In sql server configuration manager protocols for <INSTANCE>, I would like to write a sql to pull what is enabled and disabled.
    i.e.
    shared memory enabled
    tcp/ip enabled
    named pipes disabled
    via disabled
    How is this done please?
    Thanks
  2. moh_hassan20 New Member

    These information are stored in the windows registry.
    You can read registry with the command xp_regread , by passing the registry key (easily you can find it)
    check: http://www.kodyaz.com/articles/article.aspx?articleid=48

Share This Page