September 22, 2011 at 1:20 pm
I know we can use ServerProperty, @@Version etc to find out the current version of an instance. But, how can we get to know the service packs/CU installation history for an instance? I am wondering whether we have a db_version kinda table somewhere.
September 22, 2011 at 1:58 pm
or try the registry via xp_regread and there are other options as well
http://support.microsoft.com/default.aspx?scid=kb;en-us;321185#3
---------------------------------------------------------------------
September 22, 2011 at 3:41 pm
No good way, but one thing I've done is have a job store the current version in a table in each db. That way if I restore a db in DR, I know what patch level it was at.
You could modify it to store the version history with a date as well.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply