Hello- 

Recently, our server has been hit HARD by the user registration bots, and is causing SERIOUS database bloat, which subsequently is causing performance issues server wide. In some cases, we have sites with over 30,000 users. I've since disabled the user registrations on all of our sites, but now I am left with the problem of deleting all these fake user accounts / profiles. 

I've tried using the script 

"update UserPortals

Set Authorised='False' where Authorised='True'"

and then "deleting unauthorized users", but on the site I tried that on, it completely crashed the whole server. (i attempted to delete around 1500 users at once, which I imagine was too much of a strain on the server) 

Can anyone help me figure out how I can delete the users in a different way? Is there an SQL script I can run that will delete unauthorized users from the server side, rather than from the front end DNN side? Would this help? 

Any advice on getting rid of massive amounts of users / profiles on our server would be greatly appreciated. 

I didn't think so- We are supposed to have managed servers, but they claim this does not fall into their services. I do know that they install the initial version of DNN and we just develop the skins and front end build.  

Just for my own understanding, is there an SQL command we could run that would mass delete unauthorized users (or just users in general) ? 

BTW Sebastian, I wanted to personally thank you for your help- you seem to always be the guy who replies to my posts with helpful tips and fixes. You definitely know our stuff :)