Summary

This article highlights two methods for determining what version of Microsoft SQL Server is running.

Resolution 1

Open Microsoft SQL Server Management Studio and connect to the desired SQL Server. Look for the version number next to the instance name.

• 9.x.x is Microsoft SQL Server 2005
• 10.x.x is Microsoft SQL Server 2008

Resolution 2

Run the following query on the desired SQL Server instance:

select @@version

Related Links

See the following Microsoft Knowledge Base article for more information.

321185 How to determine the version and edition of SQL Server and its components.