Remote command and powershell

• Kwisatz78

  SSChampion

  Points: 12478

  More actions

  September 26, 2012 at 3:58 am

  #282189

  Hi all

  I have a situation where I need to run a cmd line on a remote server and have the results of that command line returned into a table from the calling SQL instance. I have been looking at powershell to do this as it doesn't look like I can use XP_cmdshell.

  Does anyone have any pointers as to if this is possible?

  Thanks

• Scott D. Jacobson

  SSCertifiable

  Points: 6149

  More actions

  September 26, 2012 at 11:51 am

  #1542558

  This article may have what you're looking for: http://technet.microsoft.com/en-us/library/dd819505.aspx