USE [master]; GO IF DATABASEPROPERTY('foo','Version') > 0 DROP DATABASE [foo]; GO CREATE DATABASE [foo] ON PRIMARY ( NAME = 'foo_data', FILENAME = 'C:\temp\foo_data.mdf', SIZE = 5120 KB, MAXSIZE = 5120 KB ) LOG ON ( NAME = 'foo_log', FILENAME = 'C:\temp\foo_log.ldf' ) GO EXEC sp_cycle_errorlog; GO USE [foo]; GO CREATE TABLE Table1 ( Col1 char(8000) DEFAULT('a') ) GO USE [foo]; GO SELECT SUM(used_pages) * 8 AS [space_usage_kb] FROM sys.allocation_units A JOIN sys.partitions P ON (A.[type] = 2 AND P.[partition_id] = A.[container_id]) OR (A.[type] IN (1,3) AND P.[hobt_id] = A.[container_id]) GO INSERT INTO Table1 DEFAULT VALUES; GO 245 SELECT SUM(used_pages) * 8 AS [space_usage_kb] FROM sys.allocation_units A JOIN sys.partitions P ON (A.[type] = 2 AND P.[partition_id] = A.[container_id]) OR (A.[type] IN (1,3) AND P.[hobt_id] = A.[container_id]) GO EXEC sp_readerrorlog 0,1,'Policy'; EXEC sp_readerrorlog 0,1,'34052';