Home Forums SQL Server 2014 Administration - SQL Server 2014 Get Object Name from database_id, file_id, Page_id RE: Get Object Name from database_id, file_id, Page_id

  • March 5, 2014 at 11:39 am

    #1694440

    Potentially. I haven't tried this because I don't have a 2012 instance available. It's undocumented.

    SELECT *

    FROM sys.dm_db_database_page_allocations(DB_ID('<Database Name>'), NULL, NULL, NULL, 'DETAILED') dpa

    WHERE allocated_page_file_id = @FileID AND allocated_page_page_id = @PageID

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass