First you need to change the permissions to allow xp_cmdshell: [code language=”sql”] — To allow advanced options to be changed.
Author: Pantelis Apostolidis
Pantelis Apostolidis is a Cloud Solutions Architect at Microsoft and an ex Microsoft Azure MVP. For the last 15 years, Pantelis has been involved to major cloud projects in Greece and abroad, helping companies to adopt and deploy cloud technologies, driving business value. He is entitled to a lot of Microsoft Expert Certifications, demonstrating his proven experience in delivering high quality solutions. He is an author, blogger and he is acting as a spokesperson for conferences, workshops and webinars. He is also an active member of several communities as a moderator in azureheads.gr and autoexec.gr. Follow him on Twitter @papostolidis.
Simple way to manage Automatic Start for multiple VMs at once
A simple command to see all Automatic Start actions is to run: [sourcecode language=”powershell”] get-vm -ComputerName HypervHost | select name,auto* [/sourcecode]