One of my coworkers is trying to figure out how to copy nested tables;
he's looking at using the schema and traveling down the table hierarchy
finding foreign keys and recreating those tables. I've been helping
him out with it here and there and was wondering if anyone knew how to
copy nested tables with an easier way. Is there an embedded function
(stored procedure) that does this?

or something within DTS that does the same thing?

We're using SQL 2003 servers