How to Remove Padlocks From Child Collections

THis information was provided originally by John Kaminski johntk@umich.edu

John used the following procedure to get rid of the padlocks on the child sites. After he removed the locks, he removed the address from the parent site to the child site. His parent site was only being used to run reports so removing the address caused no problems for him.

1. Stop SMS_EXECUTIVE.
   
   
2. Stop SMS_SITE_COMPONENT_MANAGER.
   
   
3. Stop Windows Management.
   
   
4. Run SQL Query Analyzer.
   
   
5. Select SMS as your DB.
   
   
6. Type and execute( Green triangle ):
   
   select * from collections
   
   In a normal situation, all Flag ID columns must be either 17 or 18. Let's select only one collection for our test. For example, SiteID is SMS00004. It might be ALL Windows NT workstation Systems.
   
   
7. Type and execute:
   update collections set flags='18' where siteID='SMS0004'
   
   
8. Go back to SMS Admin Console.
   
   
9. Refresh Collections and check if lock symbol is still there. If not, Run that collection