pages of table sysindexkeys - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

pages of table sysindexkeys

Author

Topic

pprithvi05
Starting Member

3 Posts

Posted - 2011-05-31 : 08:55:11

Hi,
I am trying to access pages of table sysindexkeys in sql server 2000.
I used the following command to list the pages corresponding to this table

DBCC TRACEON (3604)
GO
Declare @DBID Int, @TableID Int
Select @DBID = db_id(), @TableID = object_id('sysindexkeys')
DBCC ind(@DBID, @TableID, -1)
GO

But could not succeed. The tables in the database has indexes and i am also able to view the sysindexkeys table using the query

select * from sysindexkeys

Are there no data pages allocated to this table in the database?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources