Minggu, 06 Februari 2011

Using DBCC PAGE

DBCC PAGE is an undocumented – and unsupported – DBCC statement in SQL Server for dumping the raw contents of a single database page.   It will return all the metadata stored in the page, and with the right detail level parameter – return the user data as well. Since this is not documented and not supported – you use this at your OWN RISK.The format in SQL Server 2008 is as follows:DBCC PAGE ( [

Tidak ada komentar:

Posting Komentar