CODEWITHSUNDEEP
sql-serversql-server-2008-r2
Nick
Nick

Reputation: 500

what is latest update installed on sql server 2008 r2?

I am running SQL Server 2008 R2. How can I find out what is the latest updates I have installed on my SQL Server? Is there some sql command I can enter to findout?

thanks nick

Upvotes: 0

Views: 32

Answers (1)

Rahul
Rahul

Reputation: 77926

If you know your installed SQL instance name and connect to it; then run the below command to know the information about installed version/edition

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

Upvotes: 1

Related Questions