Install SP4 for SQL server through batchfile

• Trooper09

  SSCrazy

  Points: 2047

  More actions

  December 22, 2011 at 1:16 pm

  #250261

  I am in the process of installing Service Packs for 2k5 and was wondering if I can create a batch file which would install SP and place it in a network drive and then call it from a list of servers .

  Thanks in advance.

• okbangas

  SSChampion

  Points: 11773

  More actions

  December 23, 2011 at 12:16 am

  #1425043

  I think this will work for SQL Server 2005 as well, but I am not 100% sure: How to: Install SQL Server 2008 SP1 from the Command Prompt.

  ---

  
  Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

  Concatenating Row Values in Transact-SQL[/url]