Get Stored Procedures parameter names and types...

Hot Topic

Which Edition of Sql server can run on XP with utility to create table?
Change query issues
How to change a field's type?
Concatenating Strings
Reporting services -Help please :-)
Stored Proc Input Parameter Limited?
Using variables in data flow Script component
SQL Reporting Services problems... urgent
Excel problem
Excel columns to a temp table in SQL

SQL Server

A call to SQL Server Reconciler failed. SQL Server 2005, SQL Server Mobile merge replication
How to troubleshoot intermittent lockups
Weird deployment error
Cube Browser FAILS to open. It HANGS
SQL 2005 Upgrade Advisor question
External program (C#) to call and modify variables of a SSIS package?
Connecting to SQL Server with a login form.
Problem adding Annotations to KPIs
Intermittent Error 40 on Report Manager
SQL Server pricing

Get Stored Procedures parameter names and types...

Sorry if I haven't choose appropriate forum for this question.

I have MSSQL05 beta. I know how to list all stored procedures in selected database (everything is in localhost). I need to list parameter names and types for selected stored procedure(s).
How can I do that or anything that can return parameter names and types

It's windows application.

Answer this question

Get Stored Procedures parameter names and types...

  • Steve Culver - MSFT

    I will move to non-beta.

    Thanks for the reply. This is what I wanted.

  • MaryJones

    You should move to a non-beta version as you are breaking the EULA with using the old version, but anyway, the parameters can be views with the

    INFORMATION_SCHEMA.Parameters

     view.

    SELECT *
    FROM INFORMATION_SCHEMA.Parameters


    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
  • Get Stored Procedures parameter names and types...
Answer this question