Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Unanswered: Automation on SQL Server

    Hello Experts,

    I am a New Bee in SQL.I would like to know,As a System Admin I would like to automate the task of keeping the SQL Server up to date with latest Service Packs and Patches.
    Is there any procedure / Software where I can automatically download the patch / sp's from the site and install on the servers or maybe schedule the task for every month.

    I would appreciate a reply from the experts

    Best Regards


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    I don't know of any way provided by Microsoft, but there are third party products that will do that. I would very strongly recommend against using an automated update for MS-SQL except in very limited circumstances.

    SQL Updates often require minor modifications to existing code or to operations procedures because the service packs change the way that the server itself works. Because SQL is the most customizable of the server products, the impact of the service packs need to be considered before you apply the service pack, not dealt with after you've applied it!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts