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?
During the weekend, I was asked to investigate into a deadlock in SQL Server 2014. SQL being something I don’t really fancy myself being an expert at, I had to do some refreshing. This article is a collection of my notes.