Calling a Stored Procedure from PowerShell

  • Frank Dolan

    Old Hand

    Points: 349

    Comments posted to this topic are about the item Calling a Stored Procedure from PowerShell

  • matthias.elflein

    SSC Veteran

    Points: 236

    Hi Frank,

    nice article explaining how simple it is to query SQL Server by using PowerShell. Thank you!

    If you just need to see data from multiple instances as one 'table' you can use SSMS, too.

    In SSMS Registred Servers create a server group and register your instances there. Right klick on the group and start a new query.

    SSMS is easy just to see the data. If you want to do some automization, I'd prefere your PowerShell solution.

  • Frank Dolan

    Old Hand

    Points: 349

    Thanks.

    The SSMS thing works well, but it's manual when trying to save the data. I use PoSh to let this run regularly, as you noted, in an automated fashion.

  • Jvaradi

    Newbie

    Points: 1

    Very helpful. Would also be nice to see an example where you pass parameters when calling a stored procedure from Powershell.

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

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