SP2

  • How to know that SP2 is installed to eql server or not?

  • see the following link:

    http://support.microsoft.com/kb/321185

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • run select @@version; you should get 3042 if sp2 is installed

  • Rajan John (4/28/2008)


    run select @@version; you should get 3042 if sp2 is installed

    This is true only if you haven't installed any hotfixes or cumulative updates.

    select serverproperty('productlevel') will return 'SP2' irrespective of any patches.

    Derek

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

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