Script Download: CheckSQLInstanceVersionNumber.zip
http://gallery.technet.microsoft.com/scriptcenter/Check-SQL-Server-missing-ac29a3ed

This script will demo how to check SQL Server missing update KB2277078 to prevent leak of security audit entries in TokenAndPermUserStore.

When we create and enable a SQL Server audit on a computer that is running Microsoft SQL Server 2008 R2 or Microsoft SQL Server 2008, the TokenAndPermUserStore cache store continues to grow in size. Additionally, the size does not decrease even when we run the DBCC FREESYSTEMCACHE command, this issue occurs because a memory leak occurs when a SQL Server audit is enabled on an object. To fix it, for different versions, we should install the corresponding updates.

 

image image
image image

You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery