Monday, March 26, 2012

read sql page data

can i look rows(data) from sql server data page
i can learn page information using dbcc page(...)
but i have to read data rows from page.
thanks
There are a number of print options for DBCC PAGE. Use the right one, and the data will be presented
in clear text. Experiment with print option 0, 1, 2 and 3.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Sabri AKIN" <SabriAKIN@.discussions.microsoft.com> wrote in message
news:1B2B5D9B-4AE4-46D6-BD01-6CC9AB89A19C@.microsoft.com...
> can i look rows(data) from sql server data page
> i can learn page information using dbcc page(...)
> but i have to read data rows from page.
> thanks
|||Sabri,
Not sure what you're asking. Check out:
http://support.microsoft.com/kb/q83065/
HTH
Jerry
"Sabri AKIN" <SabriAKIN@.discussions.microsoft.com> wrote in message
news:1B2B5D9B-4AE4-46D6-BD01-6CC9AB89A19C@.microsoft.com...
> can i look rows(data) from sql server data page
> i can learn page information using dbcc page(...)
> but i have to read data rows from page.
> thanks
|||This article last applied to 6.5 but was updated in 2005 so I'm not sure if
it will with 7 or 2000. Might want to Google what DBCC PAGE or something
similar.
HTH
Jerry
"Sabri AKIN" <SabriAKIN@.discussions.microsoft.com> wrote in message
news:1B2B5D9B-4AE4-46D6-BD01-6CC9AB89A19C@.microsoft.com...
> can i look rows(data) from sql server data page
> i can learn page information using dbcc page(...)
> but i have to read data rows from page.
> thanks

No comments:

Post a Comment