Mengetahui Versi SQL Server

Below is a query to get version details of SQL Server. The productversion is in the format {major revision}.{minor revision}.{release revision}.{build number}.

Query:

SELECT 
  SERVERPROPERTY('productversion'), 
  SERVERPROPERTY('productlevel'), 
  SERVERPROPERTY('edition')

Source database:

10.0.5500.0
SP3
Developer Edition (64-bit)

-----------

copas from:
http://dba.stackexchange.com/questions/33870/restore-database-from-backup-file-of-different-version-edition