SELECT SUM (row_count) FROM sys.dm_db_partition_stats WHERE object_id=OBJECT_ID('[Table Name]') AND (index_id=0 or index_id=1);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)