Joe,

Hope you are having a good month.  I was doing some site/database clean-up today and noticed something funny.  I enabled the AllowDeleteChildSites key in the web.config so I could delete some child sites that I used as "test" sites.

I deleted a couple child sites successfully using the delete button on the admin interface.  Everything went smoothly.  However, when I started browsing my remaining production sites, I noticed that all of their products, offers, etc from their web stores were all gone.  I didn't check all of other possible site features but all the standard HTML web pages and content on the remaining sites were still there.  Only items from the web stores on my remaining sites were deleted.

It seems there might be a cascading delete effect going on here that is not SiteID restrictive.  I made a SQL backup before I did this so I restored my DB no problem.  But I would like to clean-up my test data by deleting some child sites without it affecting my other production sites.  I looked at the SP: [mp_Sites_Delete] assuming this is the proc that runs to delete a child site but it doesn't appear to delete anything from web store (ws_) tables.

Let me know if you have seen this before.

2.3.3.2 MSSQL

Thanks,

Mike