by JBrooks
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
from
(
select 'ReleaseManagerTest' as DB, name, type
from ReleaseManagerTest.sys.objects
union all
select 'ReleaseManager' as DB, name, type
from ReleaseManager.sys.objects
) A
group by name, type
having count(*) <> 2
a7912fd8-5ab3-4d38-87d4-8016817a87ee|0|.0|27604f05-86ad-47ef-9e05-950bb762570c
Tags:
Development | SQL
Subscribe