check SQLServer version

/* @@version*/
SELECT @@VERSION

/* serverproperty */
SELECT
    SERVERPROPERTY('productversion') as ProductVersion,
    SERVERPROPERTY ('productlevel') as ProductLevel,
    SERVERPROPERTY ('edition') as Edition

/* @@microsoftversion */
SELECT CONVERT(varbinary,@@microsoftversion)

/* sp_server_info */
EXEC sp_server_info 2

/* xp_msver */
EXEC xp_msver 'ProductVersion'

/* watch ERRORLOG! */
declare @cmd nvarchar(200)
select @cmd = 'type '+replace(upper(reverse(substring(reverse(rtrim(filename)),charindex('\',reverse(rtrim(filename))),100))),'DATA','LOG')+'ERRORLOG | findstr [Ss]erver' from master.dbo.sysfiles where fileid = 1
exec xp_cmdshell @cmd