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 ?

  • August 27, 2014 at 9:22 am

    #1741375

    fregatepllada (8/27/2014)

    Deprecated SET FMTONLY statement did the trick

    http://msdn.microsoft.com/en-us/library/ms173839.aspx%5B/quote%5D

    also check sp_describe_first_result_set, thanks to Eirikur Eiriksson for heads up on that one!

    http://www.sqlservercentral.com/Forums/FindPost1573301.aspx