Hey Phil,

why doesn't it meet the requirements / question?

He wants to have the content of the index itself or do I missunderstand the request?

CREATE TABLE dbo.foo

(

idINTNOT NULL,

c1CHAR(20)NOT NULL,

c2DATENOT NULL,

CONSTRAINT pk_foo_id PRIMARY KEY CLUSTERED (Id)

);

GO

INSERT INTO dbo.foo (id, c1, c2) VALUES

(1, 'col1', '20140101'),

(2, 'col2', '20140201'),

(3, 'col3', '20140301'),

(4, 'col4', '20140401')

GO

CREATE NONCLUSTERED INDEX ix_foo_c2 ON dbo.foo(c2);

GO

-- check the index id's of dbo.foo

SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID('dbo.foo');

GO

-- IF nonclustered index is ID = 2

DBCC IND('demo', 'dbo.foo', 2);

-- Output of page content to client

-- after execution of DBCC IND the page with type = 2 is

-- the index page! 10 is IAM!

-- Replace the page_id with that evaluated id

DBCC TRACEON (3604);

DBCC PAGE('demo', 1, <page_id, 3);

GO

When running this script you get the list of values from one page of the index with its content!

BTW: The question was from 2012 🙂

Seems to be worthless to discuss the intention 🙂