Post reply

SQL patches

  • February 8, 2013 at 2:10 am

    #269916

    Hi, Do anyone know how to check whatever patches we have installed in SQL server? 😀

  • February 8, 2013 at 2:19 am

    #1585805

    You could execute :

    SELECT @@VERSION

    It's always cumulative :-D!

    This would help you too!

    Greetz
    Query Shepherd

  • February 8, 2013 at 6:55 am

    #1585936

    Here is a very useful site.

    http://sqlserverbuilds.blogspot.com/[/url]

    I have run into instances where the build was not listed and it was traced back to a hotfix attained directly from Microsoft for a specific issue that pushed the build number not something you could not reach unless you got a non-public patch from them.

    If that is your case then you can always retrieve the list of all patches installed to Windows, which would include the SQL Server patches, using PowerShell.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply