Checking needed parameters of stored procedure with PowerShell

Question

I have a stored procedure in SQL Server 2008 R2 that requires some parameters to be run.

Is there a way I can dynamically check the stored procedure to see which parameters are needed? It is being called via invoke-sqlcmd in powershell

marc_s · Accepted Answer · 2012-10-23 18:14:33Z

2

There are at least three ways to get information about stored procedure parameters.

Experiment with

exec sp_help <sproc>

select * from information_schema.parameters where specific_name='<sproc>'

exec sp_sproc_columns <sproc>

and see which suits your needs best.

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Oct 23, 2012 at 17:34

vonPryz

24.3k10 gold badges58 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1