5. July 2010 09:22
Real quick I wanted to know what tables and stored procs were in my ReleaseManagerTest database and not in my ReleaseManager database. So here is the SQL for that.
select min(DB) as DB, name, type
select 'ReleaseManagerTest' as DB, name, type
select 'ReleaseManager' as DB, name, type
group by name, type
having count(*) <> 2