Number of records of each table in SQL server 2000

USE pubs
GO
DECLARE @ name varchar (40)
DECLARE @ SQL VARCHAR (4000)
DECLARE authors_cursor CURSOR
SELECT Name as table Name FROM SYSOBJECTS
Where xtype = 'U'

OPEN authors_cursor

Fetch next from authors_cursor
INTO @ NAME
SET @ SQL = 'select' + @ NAME + ''' AS table NAME, COUNT (1) AS number of rows FROM '+ @ NAME
WHILE @ FETCH_STATUS = 0
BEGIN
Fetch next from authors_cursor
INTO @ NAME
SET @ SQL = @ SQL + 'Union ALL SELECT ''' + @ NAME +
'''As table NAME, COUNT (1) AS number of rows FROM '+ @ NAME
END

CLOSE authors_cursor
DEALLOCATE authors_cursor
EXEC (@ SQL)
GO