Greetings,

If the database already uploaded, anyway to delete certain users?

As far as I known, deleting users will affected at least 4 tables, which
is: -

 - aspnet_Membership
 - aspnet_Profile
 - aspnet_Users
 - aspnet_UsersInRoles

Any table I miss out?


Question
How do totally delete users with Username like '%test%' from all affected
tables?


Kindly advise.

Thanks
ascll

The easiest way to do this is via code in an ASP page, not SQL:
foreach (MembershipUser mu in Membership.GetAllUsers()) {
     if (mu.UserName.IndexOf("test") >=0 ) {
          Membership.DeleteUser(mu.UserName);
      }
}

If you want to do this directly in SQL server, don't manually modify the 
tables; instead, use the stored proc: aspnet_Users_DeleteUser.  

Steve

"ascll" wrote:


> Greetings,
> 
> If the database already uploaded, anyway to delete certain users?
> 
> As far as I known, deleting users will affected at least 4 tables, which
> is: -
> 
>  - aspnet_Membership
>  - aspnet_Profile
>  - aspnet_Users
>  - aspnet_UsersInRoles
> 
> Any table I miss out?
> 
> 
> Question
> How do totally delete users with Username like '%test%' from all affected
> tables?
> 
> 
> Kindly advise.
> 
> Thanks
> ascll
> 
> 
>