--kayit olmayan tablolar --once tablo kayitlarini size gore temp tablo icine atiyoruz SELECT OBJECT_NAME(st.object_id) TableName, st.row_count into #hede FROM sys.dm_db_partition_stats st inner join sys.tables t on st.object_id=t.object_id WHERE index_id < 2 and type='U' and row_count=0 ORDER BY st.row_count DESC --sonra temp tablodan tablo adlarini cekiyoruz. select distinct(TableName) from #hede WHERE TableName not like '%sys%' and TableName not like '%MSpeer%' Order By TableName
