I need to make my portals so that everything is based off of unique email addresses. I went ahead and updated the web.config file to properly do this and ran into a bit of a problem.  People who did have 2 or more email addresses already registered with the site, upon logging in would get a "critical error" that would state "ithe E-mail supplied is invalid."

To remedy this, I went through and deleted accounts that had multiple email addresses, and just left 1 active so that they would have something to login. The problem is, is that these accounts still will not allow people to login, and brings up the critical error nnoted above.

for instance, i had my host account registered to "whatever@domain.com" and had a few test accounts registered with the same email address. I went through and deleted all the test accounts, leaving only the host account with the "whatever@domain.com" and It will not allow me to login as host. It brings up the error. My guess is that the accounts i deleted are still listed somewhere in the system. 

Even though I deleted these accounts, are they still listed in the database? How can i compelely purge the deleted accounts so that the system thinks there's only a single address?

 Knowing nothing about tables, it scares me. I did create a backup of my database... is there where I find it? Do i open it up in a particular program? I've never had to really do anything like this before, but it sounds as though it will be necessary in order to. 

Joseph, Here's something I threw together. I was able to test it on a site that had one deleted user, so far things appear to be fine. You can run this on your Host/SQL page, so you don't need other software to execute this code.

PLEASE BACKUP YOUR DATABASE BEFORE YOU RUN THIS JUST IN CASE

/*copy below*/

delete {databaseOwner}{objectQualifier}userroles where userid=(select top 1 userid from {databaseOwner}{objectQualifier}userportals where isdeleted=1 and userid not in (select userid from {databaseOwner}{objectQualifier}userportals where isdeleted=0))

delete {databaseOwner}{objectQualifier}userprofile where userid=(select top 1 userid from {databaseOwner}{objectQualifier}userportals where isdeleted=1 and userid not in (select userid from {databaseOwner}{objectQualifier}userportals where isdeleted=0))

delete aspnet_membership where userid=( select userid from aspnet_users where username=(select username from {databaseOwner}{objectQualifier}users where userid=(select top 1 userid from {databaseOwner}{objectQualifier}userportals where isdeleted=1 and userid not in (select userid from {databaseOwner}{objectQualifier}userportals where isdeleted=0)))) 

delete aspnet_users where username=(select username from {databaseOwner}{objectQualifier}users where userid=(select top 1 userid from {databaseOwner}{objectQualifier}userportals where isdeleted=1 and userid not in (select userid from {databaseOwner}{objectQualifier}userportals where isdeleted=0)))

delete {databaseOwner}{objectQualifier}userportals where userid=(select top 1 userid from {databaseOwner}{objectQualifier}userportals where isdeleted=1 and userid not in (select userid from {databaseOwner}{objectQualifier}userportals where isdeleted=0))

delete {databaseOwner}{objectQualifier}users where userid not in (select userid from {databaseOwner}{objectQualifier}userportals) and issuperuser=0

/*end copy*/