/* First create the table */
USE pubs
go
if exists (SELECT * FROM sysobjects where name='bigrows' and type='U')
DROP TABLE bigrows
go
DROP TABLE bigrows
go
CREATE TABLE bigrows
(a int primary key,
b varchar(1600))
go
/* Insert five rows into the table */
INSERT INTO bigrows
VALUES (5, replicate('a', 1600))
INSERT INTO bigrows
VALUES (10, replicate('b', 1600))
INSERT INTO bigrows
VALUES (15, replicate('c', 1600))
INSERT INTO bigrows
VALUES (20, replicate('d', 1600))
INSERT INTO bigrows
VALUES (25, replicate('e', 1600))
go
SELECT first FROM sysindexes WHERE id = object_id ('bigrows')
go
/* Convert the value returned to a decimal by byte-swapping and then doing a hex-to-decimal conversion on the last four bytes. See Chapter 6 for details. For our example, we'll assume the converted value is decimal 249. You should replace 249 with whatever page number you get. */
DBCC TRACEON(3604)
go
DBCC PAGE(pubs, 1, <page #>, 1, 1)
go
INSERT INTO bigrows
VALUES (822, replicate('x', 1600))
go
DBCC PAGE(pubs, 1, <page #>,1,1)
go
