Need to find the table exists for a page.

• Saravanan T

  SSCrazy

  Points: 2506

  More actions

  February 6, 2011 at 11:42 pm

  #388792

  Hi

  I have a page no : 1:2345, i want to know the table stored in this page . Any way to find ???

  Regards,

  Saravanan T

  Regards,
  Saravanan

• Shawn Melton

  SSC-Insane

  Points: 24685

  More actions

  February 6, 2011 at 11:59 pm

  #1282945

  DBCC PAGE command should help you out.

  Shawn Melton
  Twitter: @wsmelton
  Blog: wsmelton.github.com
  Github: wsmelton

• M&M

  SSC-Insane

  Points: 21700

  More actions

  February 7, 2011 at 12:24 am

  #1282948

  Try this link

  http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/10/625659.aspx

  Pls check if you are getting what you are looking for.

  M&M

• Cyrille Lonyem-243779

  SSC Veteran

  Points: 225

  More actions

  February 7, 2011 at 7:25 am

  #1283105

  You may also want to look at the below article on Deciphering a SQL Server Data Page:

  http://improve.dk/blog/2009/03/26/deciphering-a-sql-server-data-page