HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

How to determine SQL server version install history? I.E. When it was updated last

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
lastinstallhistorysqlversionwasdeterminehowserverupdated

Problem

I have various SQL server installs across several machines, and a different IT staff will sometimes randomly update each machine with different service packs and cause version issues.

Is there a way to see the version update history for the different SQL machines?

Solution

Did you try this folder?

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Update Cache


I once needed it. And found all the previous setups there. You can check their last modified dates. Maybe it helps.

Code Snippets

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Update Cache

Context

StackExchange Database Administrators Q#31576, answer score: 7

Revisions (0)

No revisions yet.