PowerShell module into SQL Server

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply