SQL

go
sp_spaceused table

 

select object_name(id),rows,rowcnt from sys.sysindexes where object_name(id) in ('table')