How to know the SQL Server version and edition using SQL statement?

SheoNarayan
Posted by SheoNarayan under Sql Server category on | Views : 3960
To know the SQL Server version and edition you are running, execute following SQL statement.

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


For latest details, you cal also visit http://support.microsoft.com/kb/321185

Thanks

Comments or Responses

Login to post response