We're showing 1 page of users in our site after hard-deleting via the API -- that is, using the 'X' after deleting a user with the trash can icon.
The 1 page shows 13 users but we have 240 in dbo.Users. It is possible this is orphaned content -- we've done a few restore, retest, etc. iterations.
Since the API only shows 13 Users, and I already know deletion of Users via SSMS triggers a Cascading Delete, I should just be able to zap 227 users by a simple
WHERE UserId NOT IN (the 13 Ids we need)
Is there anyplace else I need to check for orphaned data? perhaps in any files/folders set up for these users, etc.?
since there may be a script for this, please let me know if there is one. As I have a full restore point for this database, I'll proceed with removing users with the above script since I can restore everything. I'll check forum replies and if anything else is needed I'll just go back to our baseline and include it.