Determine SQL Server Version


Here is a nice way to determine SQL Server Version Information aside from @@version:


SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)