DBCC READPAGE

The syntax for the DBCC READPAGE command is
DBCC readpage ({ dbid, 'dbname' }, fileid, pageid, formatstr [, printopt =
{ 0 | 1} ])
Does anyone know what the "formatstr" parameter is used for, and what are is
options?
Thanks
Barry McAuslinIt's an undocumented command used for testing internally - what are you
trying to do with it?
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> wrote in message
news:eVNSzGK4DHA.1596@.TK2MSFTNGP10.phx.gbl...

quote:

---

> The syntax for the DBCC READPAGE command is
> DBCC readpage ({ dbid, 'dbname' }, fileid, pageid, formatstr [, printopt =
> { 0 | 1} ])
> Does anyone know what the "formatstr" parameter is used for, and what are

---

is

quote:

---

> options?
> Thanks
> Barry McAuslin
>

---

|||I am trying to get the GAM in binary form. I am using DBCC PAGE but this
returns the whole page as text. This is proving to be a bit slow over a
WAN. I would like to get the GAM with as little network traffic as
possible.
So why do I want the GAM? I am working on a tool for SQL Server that Oracle
has that I found quite useful. If you go to www.sqlfe.com you will see what
it is.
Thanks
Barry McAuslin
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:uCDDh9S4DHA.2380@.TK2MSFTNGP10.phx.gbl...

quote:

---

> It's an undocumented command used for testing internally - what are you
> trying to do with it?
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no

---

rights.

quote:

---

> "Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> wrote in message
> news:eVNSzGK4DHA.1596@.TK2MSFTNGP10.phx.gbl...
=[QUOTE]
are[QUOTE]
> is
>

---

|||DBCC READPAGE won't do what you want. Unfortunately there's no supported way
to get pages in binary form. I can forward you contact details if you're
interested in licensing on-disk internals information etc.
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> wrote in message
news:e9hNovW4DHA.1816@.TK2MSFTNGP12.phx.gbl...

quote:

---

> I am trying to get the GAM in binary form. I am using DBCC PAGE but this
> returns the whole page as text. This is proving to be a bit slow over a
> WAN. I would like to get the GAM with as little network traffic as
> possible.
> So why do I want the GAM? I am working on a tool for SQL Server that

---

Oracle

quote:

---

> has that I found quite useful. If you go to www.sqlfe.com you will see

---

what

quote:

---

> it is.
> Thanks
> Barry McAuslin
> "Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
> news:uCDDh9S4DHA.2380@.TK2MSFTNGP10.phx.gbl...
> rights.
printopt[QUOTE]
> =
> are
>

---

|||Sure, you can contact me via the details on this page
http://www.sqlfe.com/contact.asp
Thanks
Barry
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:%23jcn5Oe4DHA.4068@.tk2msftngp13.phx.gbl...

quote:

---

> DBCC READPAGE won't do what you want. Unfortunately there's no supported

---

way

quote:

---

> to get pages in binary form. I can forward you contact details if you're
> interested in licensing on-disk internals information etc.
> Regards.
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no

---

rights.

quote:

---

> "Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> wrote in message
> news:e9hNovW4DHA.1816@.TK2MSFTNGP12.phx.gbl...
this[QUOTE]
> Oracle
> what
you[QUOTE]
> printopt
what[QUOTE]
>

---

|||An update for you - the printopt parameter is explained on pg 249 of Inside
Microsoft SQL Server 2000. I checked about the licensing details and we're
not currently entering into any new agreements for this information.
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> wrote in message
news:#yCW18i4DHA.2692@.TK2MSFTNGP09.phx.gbl...

quote:

---

> Sure, you can contact me via the details on this page
> http://www.sqlfe.com/contact.asp
> Thanks
> Barry
>
> "Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
> news:%23jcn5Oe4DHA.4068@.tk2msftngp13.phx.gbl...
> way
> rights.
> this
a[QUOTE]
see[QUOTE]
> you
> what
>

---