I need to get the record counts by modifying the following query to include the record counts.
Would I just perform a simple JOIN on sys.tables?
SELECT OBJECT_NAME(ep.major_id) AS FriendlyName,
CAST(Value AS nvarchar(500)) AS AS400Table,
OBJECT_SCHEMA_NAME(ep.major_id) as SchemaName
FROM sys.extended_properties AS ep
WHERE ep.name = N'MS_Description' AND ep.minor_id = 0
AND OBJECT_SCHEMA_NAME(ep.major_id) = 'AS400_Staging'
ORDER BY OBJECT_NAME(ep.major_id)