Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Logical Page
Message
De
25/02/2000 08:50:54
 
 
À
25/02/2000 01:53:48
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Divers
Thread ID:
00337355
Message ID:
00337409
Vues:
19
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform