Post reply

Finding which table is on a page

  • October 2, 2006 at 2:03 am

    #663538

    think you'll find the number is the object id ?   ( but i'm not 100% ) I always use server trace flags to resolve deadlocks - creates enormous logs but gets you all the data you'll ever need!  dbcc page checks pages.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • October 2, 2006 at 4:49 am

    #663546

    You can find ObjId in the page header when running DBCC PAGE.

    Kindest Regards,

    Roi Assa

  • October 2, 2006 at 7:37 am

    #663576

    Thanks, I'll have a look into DBCC PAGE

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply