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
ThanksJagan K
Andrew G
SSChampion
Points: 12809
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply