...contents with all tables of the same name in another db

basically, im duplicting a db in MS SQL 2005. once done, i need to verify that every record in db A is in db B

i can list all tables in my db with
<pre id=code><font face=courier size=2 id=code>
USE myDBName
SELECT *
FROM information_schema.Tables</font id=code></pre id=code>

but after that im lost.

any help is greatly appreciated.

- Doc

Progress is made by the discontent.

Edited by - daveblohm on 05 Nov 2008 19:03:00