Are you aware of these views:

SELECT *
FROM [INFORMATION_SCHEMA].[TABLES]

SELECT *
FROM [INFORMATION_SCHEMA].[COLUMNS]

>I need a stored proc to enumerate tables and then one to enumerate fields. This is straight from the the boss. I know how to use SQLDMO to get this but I have no experiance with stored procs. :( When it rains it pours.
>
>Joe.