(extracted from ReadmeSQL2008.htm)
SQL Server 2008 Setup installs PowerShell 1.0, which is used by the following SQL Server 2008 PowerShell features: the sqlps.exe utility; SQL Server Management Studio Object Explorer right-click menus that launch SQL Server PowerShell scripts; and creating or running scheduled SQL Server Agent PowerShell job steps. If PowerShell is uninstalled after Setup completes, these features will not function. PowerShell can be uninstalled by Windows users, and uninstalling PowerShell may be required by some Windows operating system upgrades. If PowerShell has been uninstalled and you wish to use the SQL Server PowerShell features, you must either:
- Manually download and reinstall PowerShell 1.0 from the Microsoft Download Center. Download instructions are on the Windows Server 2003 Web site.
- If you are running Windows Server 2008, PowerShell 1.0 exists in the operating system but is disabled by default. You can re-enable PowerShell from Windows Server 2008.
Note: You can’t use Powershell CTP V2 with SQL Server 2008. On Windows Servers 2008, you can install Powershell v1 after installing SQL Server 2008 CTP Feb2008.
Other Microsoft Applications using Powershell:
1. Microsoft Exchange
2. Microsoft System Virtual Machine Manager Center