We use SQLMembership provider a lot; however, we always add custom logic and extended fields in the database for the user (relating the login in the membership provider to our tables). Recently we had a request that the client wanted to "reset" their user's passwords and give be able to tell them their new password verbally.
More...
LINQ, ASP.NET
extension methods, membership, random