May 12, 2011 at 4:14 pm
Does anyone know if this is the correct syntax? Do i need to add features? I know it is best to run it manually, however, we have way too many to install one at a time. Any advice would be greatly appreciated! 🙂
exec master.dbo.xp_cmdshell 'C:\SQL2005\SQLServer2005SP4-ENU.exe /IACCEPTSQLSERVERLICENSETERMS=TRUE /Q /Action=Patch /ALLINSTANCES'
¤ §unshine ¤
May 13, 2011 at 1:54 am
I can't comment on the syntax, and I haven't tried to do this using xp_cmdshell, but I can't figure out how this would work.
It looks as though you will be running xp_cmdshell from one of the instances you want to patch. The patch process stops the SQL services, closing the connection running your xp_cmdshell. :ermm:
Do you actually mean that you will be running this from a command line prompt, not xp_cmdshell.
If so, the answer to your question is... test it.
May 13, 2011 at 9:38 am
I'll be running it from a master server... atleast I'm trying to 🙂
¤ §unshine ¤
May 13, 2011 at 9:42 am
Its better to install 1 by 1
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply