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 -- Launch the Microsoft SQL Server Enterprise Manager. Expand the Microsoft SQL Servers menu tree. Expand the Microsoft SQL Server Group menu tree. Right-click the icon for your target instance. Click Properties. Click the General tab. Look for the Product version: listing.