SELECT
SUM
(row_count)
AS
[TotalRows],
OBJECT_NAME(OBJECT_ID)
TableName
FROM
sys.dm_db_partition_stats
WHERE
index_id = 0
OR
index_id = 1
GROUP
BY
OBJECT_ID
HAVING
(row_count) = 0