Hello. I am not sure if this is possible or if I am even asking it correctly. I will give it a shot.
I have a central SMS server with SQL 2005 and 4 child primary SMS servers with SQL 2005. Administrators on the child primary SMS servers manually delete resources from the database on their server. These deletions do not migrated up to the central SMS server. This means that reports created on the central server are not accurate.
Is there anyway I can compare central server with the child server and delete resources on the central server that are not present on the child servers?
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…