Mega Code Archive
DBCC TRACEON
<![CDATA[
3> CREATE TABLE bigrows
4> (
5> a int primary key,
6> b varchar(1600)
7> )
8> GO
1>
2> INSERT INTO bigrows VALUES (5, REPLICATE('a', 1600))
3>
4> INSERT INTO bigrows VALUES (10, replicate('b', 1600))
5>
6> INSERT INTO bigrows VALUES (15, replicate('c', 1600))
7>
8> INSERT INTO bigrows VALUES (20, replicate('d', 1600))
9>
10> INSERT INTO bigrows VALUES (25, replicate('e', 1600))
11> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
1>
2> SELECT first FROM sysindexes WHERE id = OBJECT_ID ('bigrows')
3> GO
first
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------
0x830000000100
(1 rows affected)
1>
2> DBCC TRACEON(3604)
3> GO
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
1>
2> --DBCC PAGE(yourDatabaseName, 1, 249, 1, 1)
3> --GO
4>
5> INSERT INTO bigrows VALUES (22, REPLICATE('x', 1600))
6> GO
(1 rows affected)
1>
2> --DBCC PAGE(yourDatabaseName, 1, 249, 1, 1)
3> --GO
4>
5> DROP TABLE bigrows
6> GO
1>
2>
]]>