----------------------- SCRIPT 1 - Select Users ----------------------- SELECT UserID, UserName, FirstName, LastName, Email, CreatedOnDate FROM {databaseOwner}[{objectQualifier}Users] ORDER BY CreatedOnDate DESC ----------------------- SCRIPT 2 - Delete Users ----------------------- DELETE {databaseOwner}[{objectQualifier}UserRoles] WHERE UserID >= [USER_ID_START] AND UserID <= [USER_ID_END] DELETE {databaseOwner}[{objectQualifier}UserPortals] WHERE UserID >= [USER_ID_START] AND UserID <= [USER_ID_END] DELETE {databaseOwner}[{objectQualifier}UserProfile] WHERE UserID >= [USER_ID_START] AND UserID <= [USER_ID_END] DELETE {databaseOwner}[{objectQualifier}aspnet_Membership] WHERE UserId IN (SELECT UserId FROM {databaseOwner}[{objectQualifier}aspnet_Users] WHERE UserName IN (SELECT UserName FROM {databaseOwner}[{objectQualifier}Users] WHERE UserID >= [USER_ID_START] AND UserID <= [USER_ID_END] )) DELETE {databaseOwner}[{objectQualifier}aspnet_Users] WHERE UserName IN (SELECT UserName FROM {databaseOwner}[{objectQualifier}Users] WHERE UserID >= [USER_ID_START] AND UserID <= [USER_ID_END] ) DELETE {databaseOwner}[{objectQualifier}Users] WHERE UserID >= [USER_ID_START] AND UserID <= [USER_ID_END]