DECLARE @Message varchar(400) DECLARE @SQL VARCHAR(MAX) BEGIN TRY if object_ID('TempDB..#Stats') is not null drop table #Stats CREATE TABLE #Stats (TableName sysname, ROWS BIGINT, reserved VARCHAR(100), DATA VARCHAR(100), index_size VARCHAR(100), unused VARCHAR(100)) SELECT @SQL = COALESCE(@SQL,'') + ' insert into #Stats execute sp_spaceused ' + QUOTENAME(Table_Name,'''') FROM INFORMATION_SCHEMA.TABLES EXECUTE (@SQL) SELECT * FROM #Stats ORDER BY TableName END TRY BEGIN CATCH SET @Message=ERROR_MESSAGE() ... END CATCHAnyone would know what to adjust in that SQL so it will not take views?