Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Logical Page
Message
From
25/02/2000 08:50:54
 
 
To
25/02/2000 01:53:48
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
00337355
Message ID:
00337409
Views:
17
First try DBCC CHECKDB which will run DBCC CHECKTABLE on everytable in the database.

Then there's an undocumented DBCC command called DBCC PAGE that will give you the info you're looking for:

DBCC PAGE ({dbid|dbname}, filenum, pagenum [, printopt][, cache])

Try using:

DBCC PAGE (dbname, 1, 7595)

Check out page 233 of Inside SQL Server 7.0 for more info.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform