Adding PowerShell Support
Note
This discussion is based on SQL Server 2008 Enterprise Edition. SQL Server 2008 Express doesn’t provide all the same features. For example, the Express version doesn’t provide the SQL Server Agent functionality briefly discussed later.
Either during the initial installation of SQL 2008 or afterward while changing the installed features, you are able to add the SQL Server–specific PowerShell features by using the setup utility. The Management Tools-Basic feature must be added, as shown in Figure 17.3.
Figure 17.3 Installing the PowerShell features.
The Management Studio add-on is also required to get the PowerShell-specific ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
