You can use the following command line in the Microsoft SQL Studio query to obtain the current installed cumulative update or service pack in the SQL Server.
select SERVERPROPERTY('ProductLevel') as 'Product Level'
The output will return as below (depends on which version installed on your SQL Server)
- RTM = Original release version
- SPx = Service pack version
- CTPx = Community Technology Preview version
Example on our SQL server version,
