Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-26 : 07:26:11
|
| Pang writes "Hello:I have been looking at "Inside SQL Server 2000" and read that row offsets in a page are stored from the end of the page in 2 bytes. In northwind data database SQL Server 2000 I look at the first page of orders table using DBCC page(...) and I see the correct offset of 0x0060 (page no is 205 for orders table in northwind). I take my database offline and then read the binary file to look at the offset. The first record offset in the file is 0x0160. Every other record offset looks correct except the first record offset. DBCC page shows it correct. DBCC bytes show it correctly, yet when I read the file I get an incorrect offset for the first record. Can anyone shed some light on this please?Thank you," |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-10-26 : 07:28:42
|
| If all of the internal SQL Server commands show it to be correct, why does it matter that it appears incorrect in a hex editor? Very few people use SQL Server databases via a hex editor......unless you're writing a 3rd party tool for SQL Server files. |
 |
|
|
|
|
|
Record offset clarification