Check Table Spaces...............

create table DataAdmin..tblTableSizes(TableEntryID int identity(1,1) primary key,EntryDate smalldatetime not null default getdate(),TableName varchar(50),Row_Count int,ReservedSize varchar(20),DataSize varchar(20),IndexSize varchar(20),UnusedSize varchar(20),CreationDate smalldatetime )





set quoted_identifier off
GO
Use AdventureWorks2000declare @tablename varchar(50), @statement nvarchar(300), @creationdate smalldatetime
declare csrTables cursor for select top 100 percent [name] from AdventureWorks2000..sysobjects (nolock) where xtype = 'U' and left(name, 3) != 'dt_' open csrTablesfetch next from csrTables into @tablenamewhile @@fetch_status = 0beginset @statement = "insert DataAdmin..tblTableSizes(TableName, Row_Count, ReservedSize, DataSize, IndexSize, UnusedSize) exec sp_spaceused '" + @tablename + "'"set @CreationDate = (select crdate from AdventureWorks2000..sysobjects (nolock) where [name] = @tablename)exec sp_executesql @statementupdate DataAdmin..tblTableSizes set CreationDate = @CreationDate where TableName = @TableNamefetch next from csrTables into @tablenameend
close csrTablesdeallocate csrTables
set quoted_identifier onGO