When using the SqlTableProfileProvider, if you use the Membership API to delete a user programmatically it removes all entries related to that user in the database except from your custom Profile table. I could imagine this causing a lot of problems on a large site.
Has anybody came up with a way to automatically remove this data also? I think the problem lies with the UserId being different in the custom profile table to the UserId value in the other asp.net membership tables so you therefore you cant just do an SQL query and delete the row where UserId = UserId.
a good article on this
SqlTableProfileProvider is here
http://murrayon.net/2009/02/aspnet-providers-profile.html?showComment=1238705280000#c5931091117824530927
...
Go to the complete details ...