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 🙂
Microsoft Certified Master: SQL Server 2008
MVP - Data Platform (2013 - ...)
my blog: http://www.sqlmaster.de (german only!)