Solved

TSQL to list SQL server 2008 patches applied to server

Posted on 2012-04-11
1
273 Views
Last Modified: 2012-04-16
Hi,
Is there piece of TSQL which will list all patches applied to a SQL server/ SQL server Cluster.

Thanks
0
Comment
Question by:crazywolf2010
1 Comment
 
LVL 29

Accepted Solution

by:
Rich Weissler earned 500 total points
ID: 37832575
Well, the good news is that SQL patches are cumulative.  You can 'SELECT @@VER', or simply look at the value in the Management Studio Explorer, and compare it to the list of SQL Server builds to determine which patches are installed.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now