SELECT '[' + SCHEMA_NAME(t.schema_id) + '].[' + t.name + ']' AS fulltable_name,
SCHEMA_NAME(t.schema_id) AS schema_name, t.name AS table_name,
i.rows
FROM sys.tables AS t INNER JOIN
sys.sysindexes AS i ON t.object_id = i.id AND i.indid < 2
Code
select distinct convert(varchar(30),object_name(a.id)) [Table Name], a.rows
from sysindexes a inner join sysobjects b on a.id = b.id
inner join INFORMATION_SCHEMA.TABLES c on c.[TABLE_NAME] = convert(varchar(30),object_name(a.id))
where c.Table_catalog='db-name'
Code
select distinct convert(varchar(30),
object_name(a.id)) [Table Name],
a.rows from sysindexes a inner
join sysobjects b on a.id = b.id
Load balance : Server 01
