How to see what is the current service pack applied to the SQL SERVER

Question

Guys,

How do we check to see what is the latest service pack applied to the sql server?

Answer 1

0

You can run with SSMS

select @@version

And then compare to the build list on SSC...

and

or

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

answered Jun 02 '10 at 01:10 PM

sp_lock
8.1k ● 20 ● 26 ● 29

(comments are locked)