Home Forums SQL Server 2008 SQL Server 2008 - General Get resultset from query without running query. RE: Get resultset from query without running query.

  • September 8, 2013 at 12:03 pm

    #1648396

    If you are using SQL Server 2008 R2 and below, you can use FMTONLY. For SQL Server 2012 and above, you can use sp_describe_first_result_set.

    Read more about it in my post: SET options-NOEXEC v/s FMTONLY-Does FMTONLY really execute the query/workload?

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins