none
Find Row Count in Table RRS feed

Answers

  • u can use following query 


    SELECT OBJECT_NAME(OBJECT_ID) TableName, st.row_count
    FROM sys.dm_db_partition_stats st
    WHERE index_id < 2
    ORDER BY st.row_count DESC
    • Marked as answer by CarlosVelaZen Friday, December 26, 2014 1:32 AM
    Wednesday, December 24, 2014 1:59 AM

All replies