How to check the SQL Server Varsion, Name & Edition

WE can see the Sql Server Name, version, edition etc using below query:


SELECT @@SERVERNAME , 
SERVERPROPERTY('productversion'), 
SERVERPROPERTY ('productlevel'), 
SERVERPROPERTY ('edition')

No comments: