CREATE TABLE #Temp

(

TableName VARCHAR(500),

CountOf INT

)

INSERT #Temp

EXEC sp_msForEachTable

'SELECT PARSENAME(''?'', 1),

COUNT(*) FROM ? WITH (NOLOCK)'

SELECT TableName , CountOf

FROM #Temp

DROP TABLE #Temp