Check SQL Server version information

1.

SELECT @@VERSION

2.

EXEC xp_msver

3.

SELECT

SERVERPROPERTY('productversion') AS ProductVersion,

SERVERPROPERTY ('productlevel') AS ProductLevel,

SERVERPROPERTY ('edition') AS ProductEdition