How to get current MS SQL 2008 Version
Here’s a quick T-SQL to get you the current version of your SQL server.
SELECT
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY ('ProductLevel') AS ProductLevel,
SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('EngineEdition') AS EngineEdition
GO
[caption id=attachment_1506 align=alignnone width=494 caption=Microsoft SQL Server 2008 Version][/caption] You can also use:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')