Some Useful Undocumented SQL Server 7.0 and 2000 DBCC Commands

DBCC RESOURCE

This command shows the server’s level RESOURCE, PERFMON and DS_CONFIG information. RESOURCE shows addresses of various data structures used by the server. PERFMON structure contains master..spt_monitor field info. DS_CONFIG structure contains master..syscurconfigs field information.

Syntax:

DBCC resource

This is an example:

DBCC TRACEON (3604)
DBCC resource

DBCC TAB 

You can use the following undocumented command to view the data pages structure (in comparison with DBCC PAGE, this command will return information about all data pages for viewed table, not only for particular number)

Syntax:

DBCC tab (dbid, objid)

where:

dbid – is the database id

objid – is the table id

This is an example:

DBCC TRACEON (3604)
DECLARE @dbid int, @objectid int
SELECT @dbid = DB_ID(‘master’)
SELECT @objectid = object_id(‘sysdatabases’)
DBCC TAB (@dbid,@objectid)

Published with the explicit written permission of the author. Copyright 200

Pages: 1 2 3 4




Array

No comments yet... Be the first to leave a reply!