Is it possible to perform an unnattended install of service packs (SP4 is the latest) on SQL Server 2005 Express?
The only way I have found is to download the SQLEXPR32.EXE containing SP4 and run it manually for each of my instances which need it. This takes ages, but I can't get any of the command line options to work.
I do have a SQL Server 2005 (not Express) instance on the server as well, but I can download and apply the service pack to this without a problem. Is it a restriction of Express?
Any ideas?
UPDATE: It has no internet connectivity so I have to do it manually