I'm trying to upgrade the service packs of all SQL Server (2008,2008 R2 )instances in our environment.
I would like to upgrade it through a batch file instead of the GUI. In our environment we use cmd or batch file for sql installation but i'm not sure how to create a batch file for service pack upgrades.
Did anyone got a chance to work on this ? Please let me know your suggesstions or thoughts.
Fyi, i have the service pack .exe file , i'm looking for a template batch file ...once i'm ready for the upgrade i just want to update the instance name in the batch file.
Please let me know if you need more information
Thanks in advance