title: How do I verify SQL Server versions, Including version, service pack, cumulative update and patch
body: <p>I have 250 VM's for different clients using different version of SQL server installed.</p>
  
  <p>I ran the below command to get the details but the information was not successful</p>
  
  <pre><code>SELECT 
      SERVERPROPERTY('productversion'), 
      SERVERPROPERTY('productlevel'),
      SERVERPROPERTY ('edition'),  
      @@version, 
      SERVERPROPERTY('PatchLevel')
  </code></pre>
  
  <p>Can someone please help? I need the information for details like SQL Server version, service pack, cumulative update and patches installed to the server.</p>