SQL Server Performance

How to verify what components were installed?

Discussion in 'SQL Server 2005 General DBA Questions' started by xiebo2010cx, Jul 21, 2006.

  1. xiebo2010cx Member

    I need to keep records of all the SQL Server 2005 servers, it is about over 20 servers.
    Now I am going to work on a report on what components were installed on all SQL 2005 servers, if there any scripts I can use to get the installation record?
  2. satya Moderator

    On the SQL Server settings I think you can get using SQLDIAG utility and as far as Application components are concerned, I believe some kind of WMI scripting might help.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

Share This Page