PowerShell for SQL Server Sample 1

I’m experimenting more with the PowerShell Provider for SQL Server (SQLPS) and I wanted to make sure you knew that there are actually two ways to get to it:

1. Type SQLPS.EXE at a command prompt, or right-click any object in SSMS and select "Start PowerShell". This opens the SQL Server PowerShell "Minishell" that we bundle with SQL Server 2008.

2. Open the PowerShell you have and "snap-in" the SQL Server Provider by following the instructions you see near the bottom of this page: http://msdn.microsoft.com/en-us/library/cc281962.aspx

Skip to main content