TSQL to list SQL server 2008 patches applied to server

Hi,
Is there piece of TSQL which will list all patches applied to a SQL server/ SQL server Cluster.

Thanks
crazywolf2010Asked:
Who is Participating?
 
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.