간만에 짠 쿼리로구나~~~~
어차피 SQLER에서 찾아서 만든거지만. 흠흠.
DECLARE @TableName nvarchar(256)
DECLARE countTableData CURSOR LOCAL
FOR
SELECT name
FROM sysobjects
WHERE xtype = N'U'
OPEN countTableData
FETCH NEXT FROM countTableData into @TableName
While @@FETCH_STATUS = 0
Begin
DBCC UPDATEUSAGE(0,@TableName)
FETCH NEXT FROM countTableData into @TableName
End
SELECT A.name AS TableName, B.rows AS Counts
FROM sysobjects A
JOIN sysindexes B ON B.id = A.id AND B.indid <2
WHERE A.xtype = N'U'
ORDER BY 2 DESC