USE pubs
go
if exists (SELECT * FROM sysobjects where name='bigrows' and type='U')
DROP TABLE bigrows
go
CREATE TABLE bigrows
(a int identity ,
b varchar(1600),
c varchar(1600))
go
INSERT INTO bigrows
VALUES (replicate('a', 1600), '')
INSERT INTO bigrows
VALUES (replicate('b', 1600),'')
INSERT INTO bigrows
VALUES (replicate('c', 1600),'')
INSERT INTO bigrows
VALUES (replicate('d', 1600),'')
INSERT INTO bigrows
VALUES (replicate('e', 1600),'')
go
SELECT first FROM sysindexes WHERE id = object_id ('bigrows')
go
UPDATE bigrows
SET c = replicate('x', 1600)
WHERE a = 3
go
DBCC TRACEON(3604)
go
/* Replace 266 with whatever page number you got. */
DBCC PAGE(pubs, 1, 266, 1, 1)
go
