The fire-and-forget method to update SQL Server Management Studio (SSMS) automatically. The script below starts with uninstalling any installed SSMS version. Once that is succeeded, it downloads & installs the latest available version from Microsoft.
This script is ideal for in your silent, automated (unattended) deployments of SQL Servers or management servers needing this tool.
Next to this script you can also use command-line parameters to install SQL Server Management Studio.
