select ServerProperty('ServerName') as [Server Name], 
         ServerProperty('InstanceName') as [Instance Name], 
         ServerProperty('Edition') as Edition, 
         ServerProperty('ProductLevel') as [Product Level], 
         ServerProperty('ProductVersion') as [Product Version], 
         ServerProperty('Collation') as [Collation]
         
-- http://ercanbozkurt.blogspot.com.tr/2012/06/sqlserver-serverproperty-fonksiyonu.html