This blog post is pretty interesting.
SQL Server 2008 comes with sqlps.exe, which is what this guy is ranting about.
To get around it, you can do this. Open the regular powershell command prompt. Run this:
This opens up the profile used by PowerShell under your login. Now you can add these lines and save the file:
You should now be able to run SQL Server commands through the regular PowerShell prompt. Depending on how you configure and run Powershell, you may also have to add those lines to scripts you create.
I may not have this quite right. I’m still learning. Here’s a suggestion that I should be updating the console file? He’s solving the same issue though.
More as I learn more.