March 4, 2014 at 10:32 am
Hi
What's the most straight forward to determine what the last cumulative update was that was applied to SSMS?
I know that CU8 is out for SQL Server 2012, I just need to confirm which (if any) update was last applied to SSMS I'm currently looking at.
Ta.
March 4, 2014 at 10:37 am
At the top of Glenn Berry's DMV queries he does the work for you. Run the code and look at the comment block for which version you are currently on. http://sqlserverperformance.wordpress.com/2014/02/06/sql-server-diagnostic-information-queries-for-february-2014/
March 4, 2014 at 11:11 am
I simply ran @@VERSION and from the build details I was able to cross-reference with http://support.microsoft.com/kb/321185 to confirm definitively which CU has been applied.
March 4, 2014 at 11:39 am
wak_no1 (3/4/2014)
HiWhat's the most straight forward to determine what the last cumulative update was that was applied to SSMS?
I know that CU8 is out for SQL Server 2012, I just need to confirm which (if any) update was last applied to SSMS I'm currently looking at.
Ta.
select @@version and http://sqlserverbuilds.blogspot.com/
--
SQLBuddy
March 5, 2014 at 1:30 pm
Connect to the SQL/Instance in Management Studio. At the top after the Instance Name will be the Build number.
For example, SQL01ABC (SQL Server 9.0.5292). Go to http://sqlserverbuilds.blogspot.com/ to see the version/CU for the build number 9.0.5292 - 9.0 is SQL/Server 2005, 5292 is SP4 CU3 with MS11-049 Hot Fix.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply