Microsoft® SQL Server 2008 R2 Unleashed

Accessing PowerShell

Now that you have added the SQL Server–specific PowerShell features, you can access a SQL Server PowerShell session.

Note

From this point on, we make the distinction between PowerShell and SQL Server PowerShell. The details are discussed shortly, but for now PowerShell is the basic or default PowerShell console, and SQL Server PowerShell is a more restricted version of PowerShell that has all the SQL Server–specific PowerShell features packaged within it.

SQL Server PowerShell can be accessed in either of two ways:

• You can open SQL Server PowerShell via the SQL Server Management Studio by right-clicking on a particular object in the Object Explorer and selecting Start PowerShell, as shown in Figure 17.4. This way is ...