how to determine which version of sql server database engine is running code example

Example: version and edition of SQL Server Database Engine

--version and edition of SQL Server Database Engine is running

--Step: Connect to the instance of SQL Server, and then run the following query in SQL Server Management Studio (SSMS):
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Tags:

Sql Example

Related