Listing 4: Creating a Table to Hold the Output of DBCC IND for SQL Server 2005

USE master
GO
CREATE TABLE sp_table_pages
(PageFID  tinyint, PagePID int,
  IAMFID tinyint, IAMPID int,
  ObjectID int, IndexID  tinyint,
  PartitionNumber tinyint,
  PartitionID bigint,
  iam_chain_type varchar(30),
  PageType tinyint,
  IndexLevel tinyint,
  NextPageFID tinyint,
  NextPagePID int,
  PrevPageFID tinyint,
  PrevPagePID int,
  Primary Key (PageFID, PagePID))