This small script might be handy to find out tables having max rows, nothing great though. Run statements below from SQL query analyser. set nocount on select 'create table #big_tables ( Table_namevarchar(75) null, Row_countint null )' +char(13) +'set nocount on '+char(13) +'declare @Table_name as varchar(75)' +char(13)+ 'declare @count as integer' select 'set @table_name = '+''''+ table_name +''''+char (13)+ 'begin '+ char(13)+ 'select @count = count(*) from ' + table_name +char(13)+ 'if @count > 100000 ' + char(13)+ char(13) + 'insert into #big_tables (table_name, Row_count) select @table_name, @count ' +char(13)+ 'end'+char(13) from information_schema.tables where table_type ='base table' print 'Select * from #big_tables order by row_count desc ' +char(13) + 'go ' +char(13)+ 'drop table #big_tables'+char(13) +'go' Copy the result (script) from the result pane in to the SQL Query window and run again. Now You get the list of tables having rowcount more than 100000 are now listed in ascending order. This number can be actually changed from the SQL statement part. Further EXEC sp_spaceused can be used to find more about the interested tables. Assumptions: All the objects are under dbo ownership within the Schema. SQL Query analyser is set to Text mode. Thanks to Forum Admin and others for accommodating my small script.