SQL Server 2008, Powershell and Web Services

Question

Hi,

Powershell provides the New-WebServiceProxy cmdlet which allows for a web service proxy object to be created.

However the Powershell in SQL Server 2008 doesn't appear to support this. Is there a way to get SQL Server's Powershell to support the New-WebServiceProxy cmdlet?

Many thanks.

Answer 1

The short answer is no. sqlps is minishell, where the only cmdlets implemented where those available in V1. New-WebServiceProxy was added in PowerShell V2. Note this does not mean sqlps is V1, rather the sqlps host implements a RunspaceConfiguration with explicitly defined cmdlets being the only cmdlets available in the host.

For a longer explanation see my post on sqlps.

You can of course use New-WebServiceProxy from the regular powershell.exe host.