Calling a Stored Procedure from PowerShell

Question

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

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

matthias.elflein SSC Veteran Points: 241 More actions · Answer 1

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 Say Hey Kid Points: 693 More actions · Answer 2

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 More actions · Answer 3

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