SQL Forward pointers
SQL
Download (.zip)
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
|