Microsoft® SQL Server 2012 Unleashed

Accessing SQL Server PowerShell

SQL Server PowerShell can be launched in many different ways, including the following:

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 14.4. This way is handy because it provides a prompt in the SQL module (which is discussed shortly) in the location of the object that was right-clicked.

FIGURE 14.4 Accessing PowerShell via SSMS.

Open SQL Server PowerShell directly from regular ...