Identifying Page numbers associated with extents

[Joe Kusek]

When running the DBCC newalloc command I get some errors like the following:
"extent 51400 is in the wrong segment"
"chain processed with bad segment for object 448004627"
I've checked the system tables and system stored procedures and see no reference to page numbers being mapped to segments or identifying which extents are associated to which tables. I'm trying to determine which pages are associated with these extents so that I can print them to view the content. Any ideas how to determine the page numbers associated with extents and which extents are associated with each table?

[JoanO]

I'm not sure that this will help because I haven't run it in a very long time.
dbcc extentcheck(dbid, object_id, index_id, sortbit)


On 2/9/99 5:04:27 PM, Joe Kusek wrote:
> When running the DBCC newalloc command I get some errors like the
> following:
"extent 51400 is in the wrong segment"
"chain
> processed with bad segment for object 448004627"
I've checked the
> system tables and system stored procedures and see no reference to page
> numbers being mapped to segments or identifying which extents are
> associated to which tables. I'm trying to determine which pages are
> associated with these extents so that I can print them to view the content.
> Any ideas how to determine the page numbers associated with extents and
> which extents are associated with each table?

[Greg]

also, look at dbcc page()

On 2/10/99 1:43:06 PM, JoanO wrote:
> I'm not sure that this will help because I haven't run it in a very
> long time.
dbcc extentcheck(dbid, object_id, index_id, sortbit)


On
> 2/9/99 5:04:27 PM, Joe Kusek wrote:
> When running the DBCC newalloc
> command I get some errors like the
> following:
"extent 51400 is in
> the wrong segment"
"chain
> processed with bad segment for
> object 448004627"
I've checked the
> system tables and system
> stored procedures and see no reference to page
> numbers being mapped to
> segments or identifying which extents are
> associated to which tables.
> I'm trying to determine which pages are
> associated with these
> extents so that I can print them to view the content.
> Any ideas how to
> determine the page numbers associated with extents and
> which extents
> are associated with each table?