Post reply

Apply Service Pack 2 on SQL Server 2005

  • July 22, 2009 at 2:40 am

    #134130

    Dear All,

    How to apply the SP 2 on existing SQL Server 2005 ? How can I verify that SP2 has ben applied or not ?

    Kindly reply

  • July 22, 2009 at 2:41 am

    #1028139

    select @@version o/p will tell you.

  • July 22, 2009 at 3:06 am

    #1028155

    Thanks.:-)

  • July 22, 2009 at 3:29 am

    #1028169

    Use this command

    select serverproperty('ProductLevel')

    This is better when compared to select @@version

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • July 22, 2009 at 6:08 am

    #1028231

    Service Pack 3 has been out for a while now, you would be better off going straight to that.

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

  • July 22, 2009 at 6:13 am

    #1028237

    apply by ensuring all connections to the databases are stopped, backup your databases, then run the installation file and follow instructions. The id you install with shoould ahve admin rights on the server. Apply to a test server first for practice and to prove your app is ok with it.

    Be warned this cannot be rolled back, to remove it you would have to uninstall\reinstall SQL, so make sure you are able to do that if you have to.

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

Viewing 6 posts - 1 through 5 (of 5 total)

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