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')

Comments