Issue: How to use query to find the Microsoft SQL version and Service pack for SQL?
I wanted to know how to find the service pack version installed on my SQL server. I foudn the following query that gives details of it.
Open the SQL Management studio and run the below query.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')