Ads 720 x 90

Finding the No.Of Rows of each table

CREATE Table #t (Name varchar(100), Row int, Reserved Varchar(32), data varchar(32), IndexSize varchar(32), Unused varchar(32))
INSERT INTO #tExec sp_MSforeachtable @command1="Exec sp_SpaceUsed '?' "
SELECT Name, RowFROM #t
DROP TABLE #t

Related Posts

There is no other posts in this category.

Total Pageviews

Subscribe Our Newsletter