Home Forums SQL Server 2008 SQL Server 2008 - General How to get the resultset datatypes of a stored procedure ? RE: How to get the resultset datatypes of a stored procedure ?

  • February 21, 2012 at 3:51 am

    #1449564

    deepkt (2/21/2012)

    Thanks for the reply Eugene Elutin.

    Is there any other way without configuring Ad Hoc Distributed Queries option?

    Thanks

    Stored procedures actually do not have an explicit metadata contract.

    If you do want that, use a table valued function instead.

    Stored procedures are not parameterized views

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP