Version History

  • 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.

  • not within SQL but there is this

    ---------------------------------------------------------------------

  • 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

    ---------------------------------------------------------------------

  • 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