Calling a Stored Procedure from PowerShell


One of the DBAs at our company recently wanted to execute a stored procedure to get data from some of our databases. We have a number of databases that are used by different customers, all of which are the same in terms of the schema and objects. The data is different, so when we call a stored procedure in each database, we get the results specific to that customer.

This article will showcase a short solution I put together in PowerShell to allow the DBA to quickly execute this stored procedure against multiple databases without having to connect to each