Detecting the Microsoft SQL Server version

The following SQL query may be run through any SQL interface, including Query Analyzer -- 

SELECT @@VERSION


Alternately, if you have console access to the SQL Server host, you may use the following steps --

  1. Launch the Microsoft SQL Server Enterprise Manager.
  2. Expand the Microsoft SQL Servers menu tree.
  3. Expand the Microsoft SQL Server Group menu tree.
  4. Right-click the icon for your target instance.
  5. Click Properties.
  6. Click the General tab.
  7. Look for the Product version: listing.
Referenced by...