Execute powershell command

Question

I need to Open Url using T-Sql something like below...

declare @sql varchar(200)

set @sql =  'powershell.exe start-process ("http://myserver:8080/ExternalService.svc?wsdl")'

EXEC xp_cmdshell @sql

Thanks For the Help 

---

Rohan

Answer 1

Hi - this URL might help in framing the query-

http://social.technet.microsoft.com/Forums/en-US/winserverpowershell/thread/e54555bd-00bb-4ef9-9cb0-177644ba19e2

Answer 2

T-SQL does not seem to be the right tool for the job. What do you mean by opening a URL? 

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog