openquery and DBCC

• msimone

  SSCommitted

  Points: 1842

  More actions

  October 3, 2013 at 4:01 am

  #283969

  Hello.

  This query

  select *

  from openquery([ServerName],'exec(''SET FMTONLY OFF; dbcc page(20,1,192963 ,0) with tableresults'')')

  works fine in SQL SERVER 2008R2

  But in SQL SERVER 2012, the next message:

  Mens 11527, Level 16, State 1, Procedure sp_describe_first_result_set, Line 1

  The metadata could not be determined because statement 'dbcc page(20,1,192963 ,0) with tableresults' does not support metadata discovery.

  Why?

  There is other way to determine the object with this page number?

  Thanks.