PowerShell in SQL Server 2008
From PowerShell in SQL Server 2008
The SQL Server team have approached PowerShell support in a different manner to other Microsoft products. They have chosen to create a SQL Server specific version of PowerShell in which the SQL Server functionality is pre-installed. This means that there will be two versions of PowerShell on any machine with SQL Server 2008 installed:
- The original PowerShell
- The SQL Server specific version including the SQL Server provider
There are a number of points that must be remembered regarding the SQL Server PowerShell console:
The SQL Server PowerShell console is closed. It is not possible to use Add-PSSnapin to add additional functionality.
Join the rant here : SQL Server 2008 + PowerShell = NO NO NO NO NO!
Protest,
Greetings /\/\o\/\/