PowerShell module into SQL Server

• jvkondapalli

  SSCommitted

  Points: 1587

  More actions

  December 10, 2013 at 1:44 pm

  #301358

  Hello,

  I'm trying to find a way to burry my PS module into extended stored procedure(XP) in sql server.

  Any help in guiding me in this direction is highly appreciated.

  Thanks in Advance

  Jagan K

  Thanks
  Jagan K

• Andrew G

  SSChampion

  Points: 12809

  More actions

  December 10, 2013 at 9:38 pm

  #1672490

  Extended stored procedures only support C# and VB languages (also you should be using SQLCLR instead of XPs). You might be able to do it by calling powershell from C# as per this article http://www.codeproject.com/Articles/18229/How-to-run-PowerShell-scripts-from-C

  However, you're probably better off enabling xp_cmdshell and running powershell from there in a regular stored procedure.