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 ( [
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar