Duplicate entries in main collection 1

[Wade1]

Is there any SQL script or tool available to remove duplicate entries in the SMS database. In some instances I will have two or three entries for one machine, one is shown as a client some not. Weird.

Is there anyway to stop this happening ?

 

[RodTrent]

Here's a few links to resources that will help you:

http://www.microsoft.com/smsmgmt/techdetails/newuid.asp

http://www.myitforum.com/articles/1/view.asp?id=4489

http://www.myitforum.com/articles/1/view.asp?id=233

http://www.myitforum.com/articles/1/view.asp?id=1779

http://www.myitforum.com/articles/1/view.asp?id=232

http://www.myitforum.com/inc/upload/2844Duplicate GUID Detection and Removal.doc

http://www.myitforum.com/inc/upload/728725NEWUID.zip

http://www.myitforum.com/articles/1/view.asp?id=586

http://www.myitforum.com/articles/1/view.asp?id=732

Rod Trent
Microsoft.MVP.SMS
=======================================
Main site:

http://www.myITforum.com

=======================================