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...
> 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 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...
> 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.
> "Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> wrote in message
> news:eVNSzGK4DHA.1596@.TK2MSFTNGP10.phx.gbl...
> > 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 McAuslin
> >
> >
>|||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...
> 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...
> > 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.
> >
> > "Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> wrote in message
> > news:eVNSzGK4DHA.1596@.TK2MSFTNGP10.phx.gbl...
> > > 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 McAuslin
> > >
> > >
> >
> >
>|||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...
> 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...
> > 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...
> > > 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.
> > >
> > > "Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> wrote in message
> > > news:eVNSzGK4DHA.1596@.TK2MSFTNGP10.phx.gbl...
> > > > 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 McAuslin
> > > >
> > > >
> > >
> > >
> >
> >
>|||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...
> 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...
> > 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...
> > > 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...
> > > > 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.
> > > >
> > > > "Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> wrote in message
> > > > news:eVNSzGK4DHA.1596@.TK2MSFTNGP10.phx.gbl...
> > > > > 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 McAuslin
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>