%META:TOPICPARENT{name="ConfigTroubleshootSQL"}%
= 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.